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.

System_CAPS_ICON_note.jpg 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. Click here 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 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.

Analysis Services Tutorial Scenario
Multidimensional Modeling (Adventure Works Tutorial)

Community Additions

ADD
Show: