Export (0) Print
Expand All

Defining and Browsing Perspectives

A perspective can simplify the view of a cube for specific purposes. By default, users can see all elements in a cube to which they have permissions. For more information, see Configuring Access to Analysis Services. What users are viewing when they view an entire Microsoft SQL Server 2005 Analysis Services (SSAS) cube is the default perspective for the cube. A view of the whole cube can be very complex for users to navigate through, especially for users who only need to interact with a small part of the cube to satisfy their business intelligence and reporting requirements. To reduce the apparent complexity of a cube, you can create viewable subsets of the cube, called perspectives, which show to users only a defined part of the measure groups, measures, dimensions, attributes, hierarchies, Key Performance Indicators (KPIs), actions, and calculated members in the cube. This can be particularly useful for working with client applications that were not written for a previous release of Analysis Services. These clients have no concept of display folders or perspectives, for example, but a perspective appears to older clients as if it were a cube. For more information, see Perspectives, and Defining and Configuring a Perspective.

ms167223.note(en-US,SQL.90).gifNote:
A perspective is not a security mechanism, but instead is a tool for providing a better user experience. All security for a perspective is inherited from the underlying cube.

When you define a new perspective in SQL Server Analysis Services, you first click New Perspective on the toolbar of the Perspectives tab in Cube Designer, and then define a name for the perspective. When you create a new perspective, all Analysis Services objects in the cube that appear in the Cube Objects list initially appear in the perspective. To remove these objects, you just clear the check box for the object that you want to remove from the perspective.

In the tasks in this topic, you will define several different perspectives and then browse the cube through each of these new perspectives.

  1. Open Cube Designer for the Analysis Services Tutorial cube, and then click the Perspectives tab.

    All the objects and their object types appear in the Perspectives pane, as shown in the following image.

    Perspectives pane of Cube Designer
  2. On the toolbar of the Perspectives tab, click New Perspective.

    A new perspective appears in the Perspective Name column with a default perspective name of Perspective, as shown in the following image. Notice that the check box for every object is selected; until you clear the check box for an object, this perspective is identical to the default perspective of this cube.

    New perspective in Perspective Name column
  3. Change the perspective name to Internet Sales.

  4. Set Internet Sales-Sales Amount as the default measure.

    When users browse the cube by using this perspective, this measure will be the measure that the users will see unless they specify some other measure.

    ms167223.note(en-US,SQL.90).gifNote:
    You can also set the default measure for the whole Analysis Services Tutorial cube in the Properties window on the Cube Structure tab for the cube.

  5. Clear the check box for the following objects:

    • Reseller Sales measure group
    • Sales Quotas measure group
    • Sales Quotas1 measure group
    • Reseller cube dimension
    • Reseller Geography cube dimension
    • Sales Territory cube dimension
    • Employee cube dimension
    • Promotion cube dimension
    • Reseller Revenue KPI
    • Large Resellers named set
    • Total Sales Amount calculated member
    • Total Product Cost calculated member
    • Reseller GPM calculated member
    • Total GPM calculated member
    • Reseller Sales Ratio to All Products calculated member
    • Total Sales Ratio to All Products calculated member

    These objects do not relate to Internet sales.

    ms167223.note(en-US,SQL.90).gifNote:
    Within each dimension, you can also individually select the user-defined hierarchies and attributes that you want to appear in a perspective.

  1. On the toolbar of the Perspectives tab, click New Perspective.

  2. Change the name of the new perspective to Reseller Sales.

  3. Set Reseller Sales-Sales Amount as the default measure.

    When users browse the cube by using this perspective, this measure will be the measure that the users will see unless they specify some other measure.

  4. Clear the check box for the following objects:

    • Internet Sales measure group
    • Internet Sales Reason measure group
    • Customer cube dimension
    • Internet Sales Order Details cube dimension
    • Sales Reason cube dimension
    • Internet Sales Details Drillthrough Action drillthrough action
    • Total Sales Amount calculated member
    • Total Product Cost calculated member
    • Internet GPM calculated member
    • Total GPM calculated member
    • Internet Sales Ratio to All Products calculated member
    • Total Sales Ratio to All Products calculated member

    These objects do not relate to resellers sales.

  1. On the toolbar of the Perspectives tab, click New Perspective.

  2. Change the name of the new perspective to Sales Summary.

    ms167223.note(en-US,SQL.90).gifNote:
    You cannot specify a calculated measure as the default measure.

  3. Clear the check box for the following objects:

    • Internet Sales measure group
    • Reseller Sales measure group
    • Internet Sales Reason measure group
    • Sales Quotas measure group
    • Sales Quotas1 measure group
    • Internet Sales Order Details cube dimension
    • Sales Reason cube dimension
    • Internet Sales Details Drillthrough Action drillthrough action
  4. Select the check box for the following objects:

    • Internet Sales Count measure
    • Reseller Sales Count measure

  1. On the Build menu, click Deploy Analysis Services Tutorial.

  2. When deployment has successfully completed, switch to the Browser tab, and then click Reconnect.

  3. Clear all measures and hierarchies from the Data pane and all dimensions from the Filter pane.

  4. Review the measures and dimensions in the Metadata pane.

    Notice that all the defined measures and measure groups appear.

  5. On the toolbar of the Browser tab, select Internet Sales in the Perspective list and then review the measures and dimensions in the Metadata pane.

    Notice that only those objects that are specified for the Internet Sales perspective appear, as shown in the following image.

    Objects for the Internet Sales perspective
  6. In the Metadata pane, expand Measures.

    Notice that only the Internet Sales measure group appears, together with the Internet GPM and Internet Sales Ratio to All Products calculated members.

  7. Expand Internet Sales, right-click Internet Sales-Sales Amount, and then select Add to Data Area.

    This measure appears in the Data pane.

  8. In the Perspective list of the toolbar of the Browser tab, select Reseller Sales.

    Notice that the Internet Sales-Sales Amount measure no longer appears in the Data pane.

  9. In the Metadata pane, expand Measures.

    Notice that the Internet Sales measure group no longer appears in the measures list.

  10. In the Perspectives list on the toolbar of the Browser tab, select Sales Summary.

  11. In the Metadata pane, expand Measures, expand Internet Sales and expand Reseller Sales.

    Notice that in each of these measure groups, only a single measure appears, as shown in the following image.

    Internet Sales and Reseller Sales measures
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft