Lesson 3: Modifying Measures, Attributes and Hierarchies
Applies To: SQL Server 2016
After defining your initial cube, you are ready to improve the usefulness and friendliness of the cube. You can do this by adding hierarchies that support navigation and aggregation at various levels, by applying formats to specific measure, and by defining calculations and relationships.
This lesson contains the following tasks:
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.