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.