A perspective is a defined subset
of a cube, and is used to reduce the perceived complexity of a cube to the
business user. It defines viewable subsets of a data model that provide
focused, business-specific, or application-specific viewpoints of the model.
Perspectives are available in both Multidimensional and Tabular versions of
Analysis Services. It is an excellent option to reduce the complexity of a
cube. It has some similarities to SQL Server Views which gives us the ability
apply abstraction over available SSAS objects (measures and dimensions, KPI and
named sets) available in an OLAP or Tabular cube. It does not require any
additional storage beyond their definition and has no effect on processing
times of a cube.
A perspective enables
administrators to create views of a cube, helping users to focus on the most
relevant data for them. A perspective contains subsets of all objects from a
cube. A perspective cannot include elements that are not defined in the parent
cube.
Cubes can be very complex objects
for users to explore in Microsoft SQL Server Analysis Services. A
single cube can represent the contents of a complete data warehouse, with
multiple measure groups in a cube representing multiple fact tables, and
multiple dimensions based on multiple dimension tables. Such a cube can be very
complex and powerful, but daunting to users who may only need to interact with
a small part of the cube in order to satisfy their business intelligence and
reporting requirements.
Step by step creating first perspective
Already I have created a cube (using
Adventure Works database)
Open the cube you will getting
the perspective tab on the editor
Click on the perspective tab
Click on the new perspective
New Perspective has been created.
Write new perspective name.
Select the Measure and dimension
according to your business.
Save that and close it.
Build the project after that deploy
the project.
Click on the cube and go the
browser tab.
Select the perspective which is
created.
You will see the measure and dimension
Now you can generate the report according
to your requirement.
Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
ReplyDeleteI have to search sites with relevant information on given topic and provide them to teacher our opinion and the article. World News
ReplyDelete