Home > SSAS > Perspectives in SSAS

Perspectives in SSAS

SQL Server Analysis Service after cube development we can use some advanced features to our cube.

Perspectives is one of the feature in SSAS. In cube designer there is one tab called  “Perspectives” where we can defined the required perspective.

Perspectives used as view , that means abstraction over available objects. In SSAS we have different objects like measures, dimension attributes, hierarchy etc. So if we define new perspective we can choose which all measures , dimension attributes, hierarchy we want to keep in newly created perspective. So once we define that user will see those many measures, dimension attributes, hierarchy which are available in the perspective.

This concept will be clear once we created the Perspective in SSAS.

Please follow the below link for more details


More technical stuff can be found in http://msbitips.com


Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Categories: SSAS Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: