Mapping Variables

After identifying variables in the data source, you must map them to TM1® objects.

Procedure

  1. Click the Maps tab, then the Cube sub-tab.
  2. You are not creating a cube, so select No Action in the Cube Action box.
  3. The Data Action is irrelevant, as you are not creating or updating a cube. You can disregard this box.
  4. The Cube Logging option is not relevant, as you are not processing data values. Leave this option unselected.
  5. Click the Dimensions sub-tab.

    This grid has a row for each variable that you identified as an Element content type. You must specify an element type and identify the dimension to which the element belongs.

  6. You are creating a new dimension, so type Example in the Dimension column for the Boston variable.
  7. Select Create from the Action drop-down list.
  8. Select Numeric from the Element Type drop-down list.

    The Boston variable is now mapped as a numeric element of a new dimension named Example.

    You can now map the variables identified as consolidations.

  9. Click the Consolidations sub-tab.

    TM1 correctly identifies both consolidation variables as members of the new Example dimension. All you have to do is identify the child variable for each consolidation.

  10. For the V1Consolidation Variable, select Massachusetts as the Child Variable.
  11. For the Massachusetts Consolidation Variable, select Boston as the Child Variable.
  12. Do not edit the Weight of either consolidation variable.

    Consolidated Variable

    Dimension

    Child​ Variable

    Weight

    Sample Value

    Component Order

    V1

    Example

    Mass.

    1.000000

    New England

    By Input

    Mass.

    Example

    Boston

    1.000000

    Massachusetts

    By Input

    All mapping is complete. If you want, you can click the Advanced tab and then click through the various sub-tabs to view the scripts generated by TurboIntegrator that create the new Example dimension and insert consolidations and elements. We will take a closer look at TurboIntegrator scripts later in this tutorial.