9.1 definition and browsing perspective

Definition and browsing perspective :

Pivot can simplify the view of a multi-dimensional dataset for a specific purpose. By default, you can view all elements in a multi-dimensional dataset that have the permission to view. For more information, see . When you view the entire Microsoft SQL Server 2005 Analysis Services (SSAs) multi-dimensional data set, you can see the default perspective of the multi-dimensional data set. For users in the navigation view, especially users who only need to interact with a small part of the multi-dimensional dataset to meet their business intelligence and report needs, the view of the entire multi-dimensional dataset is very complex. To reduce the apparent complexity of a multi-dimensional dataset, you can create a view subset of the multi-dimensional dataset, which is called "perspective" , Pivot can only display the defined parts of the measurement value group, measurement value, dimension, attribute, hierarchy, key performance indicators (KPIs), operations, and computing members in a multi-dimensional dataset. Use a client application that is not compiled for previous analysis services versions Program This approach may be particularly useful. For example, these clients do not have the concept of displaying folders or pivoting, but for earlier clients, the display of pivoting is similar to that of multi-dimensional datasets. For more information, see And .

Pivoting is not a security mechanism, but a tool for providing a better user experience. All the security of perspective is inherited from the basic multi-dimensional dataset.

 

When defining a new perspective in SQL Server Analysis Services"Perspective"Click"New Perspective"And then define the perspective name. When creating a new perspective, multidimensional data appears in"Multi-dimensional dataset object"All Analysis Services objects in the list are initially displayed in perspective. To delete these objects, you only need to clear the check boxes of the objects to be deleted from the perspective.

In the task of this topic, you will define several different pivoting, and then use each new perspective to browse the multi-dimensional dataset.

Define Internet sales perspective
Define Internet sales perspective

2. Open the multidimensional cube designer for the Analysis Services tutorial cube, and then click"Perspective"Tab.

   All objects and their object types will appear in"Perspective"Pane, as shown in.

4. In"Perspective"On the toolbar of the tab, click"New Perspective".

   The new perspective is displayed in"Perspective name"Column, and the default perspective name is"Perspective", As shown in. Note that the check boxes for each object are selected. This perspective is the same as the default perspective for this cube unless you clear the check boxes for the object.

6. Change the perspective nameInternet sales.

8. Set"Internet sales"Set to the default measurement value.

   When you use this perspective to browse multi-dimensional data sets, this metric value will be the measurement value you see (unless other measurement values are specified ).

   You can also"Multidimensional Dataset structure"In the Properties window on the tab, set the default measurement value for the entire analysis services tutorial cube.

    

9. Clear the check boxes for the following objects:

   • "Distributor sales"Measurement Group

   • "Sales quota"Measurement Group
   • "Sales quotas1"Measurement Group
   • "Distributor"Multidimensional Dataset dimension
   • "Distributor region"Multidimensional Dataset dimension
   • "Sales region"Multidimensional Dataset dimension
   • "Employee"Multidimensional Dataset dimension
   • "Promotion"Multidimensional Dataset dimension
   • "Distributor revenue"KPI
   • "Large distributors"Name set
   • "Total sales"Computing Member
   • "Total product cost"Computing Member
   • "Distributor GPM"Computing Member
   • "Total GPM"Computing Member
   • "Distributor sales rate for all products"Computing Member
   • "Total sales ratio of all products"Computing Member

   These objects are irrelevant to Internet sales.

   In each dimension, you can also separately select the User-Defined hierarchy and attributes that you want to appear in the perspective.

    

Define "distributor sales" Perspective
Define "distributor sales" Perspective

2. In"Perspective"On the toolbar of the tab, click"New Perspective".

4. Change the name of the new perspectiveReseller sales.

6. Set"Distributor sales"Set to the default measurement value.

   When you use this perspective to browse multi-dimensional data sets, this metric value will be the measurement value you see (unless other measurement values are specified ).

8. Clear the check boxes for the following objects:

   • "Internet sales"Measurement Group

   • "Internet sales reason"Measurement Group
   • "Customer"Multidimensional Dataset dimension
   • "Internet sales order details"Multidimensional Dataset dimension
   • "Sales reason"Multidimensional Dataset dimension
   • "Internet sales details drilling operation"Drilling operation
   • "Total sales"Computing Member
   • "Total product cost"Computing Member
   • Internet GPMComputing Member
   • "Total GPM"Computing Member
   • "Internet sales ratio of all products"Computing Member
   • "Total sales ratio of all products"Computing Member

   These objects are irrelevant to "distributor sales.

Define sales summary perspective
Define sales summary perspective

2. In"Perspective"On the toolbar of the tab, click"New Perspective".

4. Change the name of the new perspectiveSales Summary.

   You cannot specify the calculated measurement value as the default measurement value.

    

6. Clear the check boxes for the following objects:

   • "Internet sales"Measurement Group

   • "Distributor sales"Measurement Group
   • "Internet sales reason"Measurement Group
   • "Sales quota"Measurement Group
   • "Sales quotas1"Measurement Group
   • "Internet sales order details"Multidimensional Dataset dimension
   • "Sales reason"Multidimensional Dataset dimension
   • "Internet sales details drilling operation"Drilling operation

8. Select the check boxes for the following objects:

   • Internet sales count"Metric Value

   • "Distributor sales count"Metric Value

View multi-dimensional datasets through each perspective
View multi-dimensional datasets through each perspective

2. In"Generate"Click"Deployment Analysis Services tutorial".

4. After the deployment is completed, switch"Browser"Tab, and then click"Reconnect".

6. Slave"Data"Clear all measurement values and hierarchies in the pane, and"Filter"Clear all dimensions in the pane.

8. In"Metadata"Check the measurement value and dimension in the pane.

   Note that all defined measurement values and measurement value groups will appear.

10. In"Browser"On the toolbar of the tab, select"Perspective"In the list"Internet sales"And view"Metadata"The measurement value and dimension in the pane.

    Note that only the objects specified for the Internet sales perspective will appear, as shown in.

12. In"Metadata"In the pane, expand"Metric value".

    Note that only"Internet sales"Measurement Value group, andInternet GPMAnd"Internet sales ratio of all products"Computing member.

14. Expand"Internet sales", Right-click"Internet sales"And then select"Add to data area".

    This metric value appears in"Data"Pane.

16. In"Browser"On the toolbar of the tab"Perspective"List, select"Distributor sales".

    Please note that,"Internet sales"The metric value no longer appears in"Data"Pane.

18. In"Metadata"In the pane, expand"Metric value".

    Please note that,"Internet sales"A measurement value Group no longer appears in the measurement value list.

20. In"Browser"On the toolbar of the tab"Perspective"List, select"Sales summary".

22. In"Metadata"In the pane, expand"Metric value","Internet sales"And"Distributor sales".

    Note that only one measurement value is displayed in each measurement value group, as shown in.