Associating an Attribute with a Logical Level in Dimension Tables

Attributes can be associated with a logical level by selecting the dimensional level on the Levels tab. Measures can be associated with levels from multiple dimensions and will always aggregate to the levels specified.

Dimensions appear in the Dimensions list. If this attribute is associated with a logical level, the level appears in the Levels list.

Another way to associate a measure with a level in a dimension is to expand the dimension tree in the Business Model and Mapping layer, and then use drag-and-drop to drop the column on the target level. For more information about level-based measures, refer to Level-Based Measure Calculations Example.

To associate a measure with a logical level in a dimension

1. In the Business Model and Mapping layer, double-click a logical column.
2. In the Logical Column dialog box, click the Levels tab.
3. In the Levels tab, click the Logical Levels field for the dimension from which you want to select a logical level.
   NOTE:  In the Levels tab, in the levels list, you can sort the rows (toggle between ascending order and descending order) by clicking a column heading.
4. In the Logical Levels drop-down list, select the level.
5. Repeat this process to associate this measure with other logical levels in other dimensions.

To remove the association between a dimension and a measure

1. In the Business Model and Mapping layer, double-click a logical column.
2. In the Logical Column dialog box, click the Levels tab.
3. In the Levels tab, click the delete button next to the Logical Levels field.
4. Click OK.