Mapping Variables

Map variables by mapping elements to dimensions then mapping consolidation variables.

Procedure

  1. Map elements to dimensions.
    1. Click the Maps tab, then click the Dimensions sub-tab.

      The single variable you identified as an element displays in the grid.

    2. In the Dimension column, type DB.
    3. Select Create from the Action drop-down menu.
    4. Select Numeric from the Element Type drop-down menu.
  2. Map consolidation variables.
    1. Click the Consolidations sub-tab.

      TM1® correctly identifies each consolidation variable as mapping to the DB dimension.

    2. Set the Child Variable for each consolidation variable.

      Cons. Variable

      Child Variable

      TYPE

      SALESREP

      SALESREP

      NAME

      SALESTEAM

      TYPE