Lesson 3: Modifying Measures, Attributes and Hierarchies

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

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.

Note

Completed projects for all of the lessons in this tutorial are available online. You can jump ahead to any lesson by using the completed project from the previous lesson as a starting point. See Analysis Services samples to download the sample projects that go with this tutorial.

This lesson contains the following tasks:

Modifying Measures
In this task, you specify formatting properties for the currency and percentage measures in the SQL Server 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.

See Also

Analysis Services Tutorial Scenario
Multidimensional Modeling (Adventure Works Tutorial)