Siebel Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Columns >

Associating an Attribute with a Level in Dimension Tables

Attributes can be associated with a 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 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 the drag-and-drop feature to drop the column on the target level. For more information about level-based measures, see Level-Based Measure Calculations Example.

To associate this measure with a level in a dimension

  1. Click in the white space in the Levels list next to the dimension from which you want to select a level.
  2. Select the level.
  3. Repeat this process to associate this measure with other levels in other dimensions.

To remove an association

  1. Click the Delete button next to the level association you want to remove.

    The level is removed from the Levels list.

  2. Repeat this process to remove associations with levels in other dimensions.

 Siebel Analytics Server Administration Guide
 Published: 11 March 2004