Associate an Attribute with a Logical Level in Dimension Tables

You can associate attributes with a logical level.

You can associate measures with levels from multiple dimensions and aggregate to the levels specified. A measure is associated to a level is called a level-based measure. A level-based measure is computed at that grain, even when the query context has a lower grain. For example, if yearlySales is associated to year level, it's computed at the yearly level in the following query: Select month, yearlySales.

Dimensions are displayed in the Dimensions list. If the 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 logical layer, and then use drag-and-drop the column on the target level. See Level-Based Measure Calculations.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer .
4. In the Logical Layer pane, browse for the table with the logical column that you want to add an aggregation level to. Double-click the column.
5. In the logical table, click the Columns tab.
6. In the column table, click the column to highlight it, and then click Detail view to view its properties.
7. In the logical column's Aggregation properties, click the Aggregation Rule field and select an aggregation rule.
8. Click Add Aggregation by Level and in the Dimension field select a logical table source.
9. Click the Logical Level field and select a level.
10. Click Save.