Manually Create Dimensions in Level-Based Hierarchies

You can associate each dimension with attributes (columns) from one or more logical dimension tables and level-based measures from logical fact tables.

It's a best practice to ensure that the physical hierarchy type set in the physical layer matches the dimension properties you select in the logical layer. Also, be sure that you set the Ragged and Skipped Levels dimension properties correctly so that the queries work properly.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. In the Logical layer Logical layer icon, right-click a business model and select Create Logical Table.
  4. In Name, type a name for the logical table. Click the Type field and select Dimension.
  5. Click OK.
  6. In the new logical table's tabs click the Hierarchy tab.
  7. Click the Hierarchy Type field and either select Level-Based, or if the dimension is a time dimension, select Time.

    The Default root level field is automatically populated after you associate logical columns with a dimension level.

  8. If the hierarchy type is Level-Based, click either Ragged or Skipped Levels.
  9. Click Save.