Creating Mappings Using Multi-Dimensions

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 not available in the target application. 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:

Select Workflow, and then under Data Load, select Data Load Mapping.
In the Data Load Mapping, in the Dimensions drop-down, select the dimension name.
Select the Multi-Dimension tab.
In Multi Dimension, click Edit.
In Rule Name, specify the name of the rule.
Enter the Target Value or click to select a target value.
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.
The Dimension drop-down shows all dimensions mapped in the Import Format.
As a context, the source Segment/Chartfield column is shown in addition to the Data Table Column.
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.