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.
Procedure
To create a hierarchy:
- In the Data Project Explorer, select
a dimension entity or table in the dimensional model.
- 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 . |
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.