Create and Manage Level-Based Hierarchies in a Semantic Model

This topic provides information to help you understand and create a level-based hierarchy and its dimensions in a semantic model.

Topics:

• About Level-Based Hierarchies

• About Hierarchy Structures

• About Using Dimension Hierarchy Levels in Level-Based Hierarchies

• Automatically Create Dimensions with Level-Based Hierarchies

• Manually Create Dimensions in Level-Based Hierarchies

• Create Logical Levels in a Logical Dimension Table

• Associate a Logical Column and Its Table with a Dimension Level

• About Level-Based Measure Calculations

• Grand Total Dimensional Hierarchy Example

• Identify the Primary Key for a Dimension Level

• Add a Dimension Level to the Preferred Drill Path