Creating Mappings Using the Multi-Dimension Method

Multi-dimension mapping enables you to define member mapping based on multiple source column values. This functionality provides you with the ability to load data into dimensions unavailable in the target application. For example, the mapping for Account dimension can be based on source values of Entity, Product, and Project. This mapping enables 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:

On the Workflow tab, under Data Load, select Data Load Mapping.
From Dimensions, select the dimension name.
Select the Multi-Dimension tab.
In Multi Dimension, click Edit.
In Rule Name, enter the name of the rule.
Enter the Target Value or click to select a target value.
The target value is the EPM dimension member name.
To reverse the sign of the source account value, select Change Sign.
In Description, enter a description of the mapping.
Click Add to create blank rows for specifying mapping conditions.
In Dimension, select the dimension to add.
For context, the source Segment/Chartfield column and Data Table columns are shown.
In Condition, select the method for mapping values.
Available conditions:
- Explicit
- Between
- Like
- In
In Value, specify the dimension member name.
Repeat steps 9-12 to specify multiple conditions.
Select Apply to Rule to apply the mapping only to a specific data rule in the location.
For other data rules in the location the mapping are not applied.
By the default, mappings specified at a location are applicable to all data rules in a location.
Click Save.