• Article

Lesson 3: Modifying Measures, Attributes and Hierarchies

After defining your initial cube, you are ready to improve the usefulness and friendliness of the cube.

Note

A completed project through Lesson 2 is available by downloading and installing the samples. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

This lesson contains the following tasks:

  • Modifying Measures
    In this task, you specify formatting properties for the currency and percentage measures in the Analysis Services Tutorial cube.

  • Modifying the Customer Dimension
    In this task, you define a user hierarchy, create named calculations, modify attributes to use named calculations, and group attributes and user hierarchies into display folders.

  • Modifying the Product Dimension
    In this task, you define a user hierarchy, create named calculations, define the All member name, and define display folders.

  • Modifying the Date Dimension
    In this task, you define a user hierarchy, modify attribute member names, and use composite keys to specify unique attribute members.

  • Browsing the Deployed Cube
    In this task, you browse cube data by using the browser in Cube Designer.