Automatically Create Dimensions with Level-Based Hierarchies

You can set up a dimension automatically from a logical dimension table if a dimension for that table doesn't exist.

To create a dimension with a level-based hierarchy automatically, a semantic model examines the logical table sources and the column mappings in those sources and uses the joins between physical tables in the logical table sources to determine logical levels and level keys. As a best practice, create a dimension table with a level-based hierarchy after all the logical table sources have been defined for a dimension table.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer and locate and double-click a logical dimension table that isn't associated with any dimension.
4. In the logical table, click the Hierarchy tab.
5. In the Hierarchy Type field, select Level-Based or Parent-Child.
6. Click Save.