Creating a level within a hierarchy

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:

  1. In the Data Project Explorer, select the hierarchy in the data model.
  2. Open and complete the Create Level window.
    1. Right-click the hierarchy, then click Add Data Object > Level. The Create Level window opens.
    2. 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.

Feedback