Creating a hierarchy in a dimensional model

Use the workbench to create a hierarchy in your dimensional model. For example, create a single TIME hierarchy within a TIME dimension to track sales at the day, quarter, or year level.

Before you begin

You must have a logical data model or a physical data model. Dimensional notation must be enabled.

About this task

Procedure

To create a hierarchy:

  1. In the Data Project Explorer, select a dimension entity or table in the dimensional model.
  2. Generate a hierarchy, or create a new hierarchy:
    Option Description
    Generate a hierarchy and levels based on the dimensional notation Right-click the dimension entity or table and click Generate Hierarchy.
    Create a blank hierarchy Right-click the dimension object and click Add Data Object > Hierarchy.
    The hierarchy is created and displayed underneath the dimension entity or table. If you created a blank hierarchy, you can add levels to the dimension from the Properties view.

Feedback