Use the workbench to add a level to a hierarchy. For example,
you can add a Year level to a Time hierarchy to track sales changes
by year.
About this task
After you create a hierarchy, you can add a level to the
hierarchy.
Procedure
To create a level:
- In the Data Project Explorer, select
the hierarchy in the data model.
- Open and complete the Create Level window.
- Right-click the hierarchy, then click . The Create Level window opens.
- Select the attributes or columns that you want to use
as the level attributes, assign roles, and click OK.
The level is created and displayed under the hierarchy
object in the Data Project Explorer.