Creating Mappings Using Multi-Dimensions

You can define member mapping based on source values of multiple dimension. For example the mapping for Account dimension can be based on source values of Entity, Product, and Project. This allows for the derivation of target values based on the combination of source values. In addition, Lookup dimensions are added to Target Application registration. These dimensions contain source dimension but do not exist in the target application. They provide even more flexibility in creating multi-dimension filters. It is a way to facilitate conditional data loading,

  To create mappings using multiple dimensions:

  1. In the Dimensions, drop-down, select the source value.

  2. in the Type drop-down, select Multi-Dimension.

  3. Click Add.

    The Multi-Dimension screen is displayed.

  4. Enter the Rule Name.

  5. Enter the Target Value or click Search button. to select a target value.

    The target value is the EPM dimension member name.

  6. Enter a description.

  7. Click Save.