Add Hierarchy

Assemble the product hierarchy using the attributes from a dimension table. Hierarchies enable you to define aggregations and drill downs. This makes it easier to report on summary level and drill into details easily and within the same visualization.

Refer to the Create Hierarchy section in Recommendations and Tips to Extend the Semantic Model.

1. In step 1 of the Add a Hierarchy wizard, name your hierarchy in Hierarchy Name.
2. Select, drag, and drop available data elements into the Selected Data elements pane to design a hierarchy for the dimension.
3. In the Selected Data Elements pane, click a level to update its primary key and set its display attribute in the Properties pane.
   You can add multiple levels in your hierarchy by right-clicking at a level and selecting Add Child or Add ‘n’ Child Levels. For example, your Region Hierarchy can have Region Total at Level 1, Region at Level 2, Country at Level 3, State at Level 4, and City at Level 5.
4. Ensure Add hierarchy to Subject Area is selected and click Finish.