Lesson 3: Modifying Measures, Attributes and Hierarchies
After defining, deploying, and processing your initial cube, and then reviewing dimension and cube data in Business Intelligence Development Studio, 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 updated samples. For more information, see Obtaining Updated Samples in Installing Samples.
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 modify user hierarchies, delete unused attributes, create named calculations, modify attributes to use named calculations, and group attributes and user hierarchies into display folders.
- Modifying the Time Dimension
In this task, you modify user hierarchies, modify attribute member names, and use composite keys to specify unique attribute members.
- Modifying the Product Dimension
In this task, you define a new user hierarchy, create named calculations, define the All member name, delete unnecessary attributes, and define display folders.
- Viewing the Changes in Cube Designer
In this task, you review the effect to the Analysis Services Tutorial cube of the changes you made in the previous tasks in this lesson.
Next Lesson
Lesson 4: Defining Advanced Attribute and Dimension Properties
See Also
Concepts
Analysis Services Tutorial Scenario
SQL Server 2005 Analysis Services Tutorial