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. Multi-dimension mappings derive the target values based on the combination of source values. In addition, Lookup dimensions can be added to Target Application registration. These dimensions contain source dimensions that 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.

Note:

When using multi-dimensional mapping, the source needs to be less than or equal to 75 characters.

To create mappings using multiple dimensions:

1. On the Workflow tab, under Data Load, select Data Load Mapping.
2. From Dimensions, select the dimension name.
3. Select the Multi-Dimension tab.
4. In Multi Dimension, click Edit.
5. In Rule Name, enter the name of the rule.
6. In Target Value, specify the target dimension member.
   You can also click to select a target value.

   The target values for multi-dimensional mapping must be an explicit member name. Wildcard or special characters are not supported

7. To reverse the sign of the source account value, select Change Sign.
8. In Description, enter a description of the mapping.
9. Click Add to create blank rows for specifying mapping conditions.
10. In Dimension, select the dimension to add.
11. In Condition, select the method for mapping values.

    Available conditions:

    • Explicit

    • Between

    • Like

    • In

12. In Value, specify the dimension member name.
13. Repeat steps 9-12 to specify multiple conditions.
14. 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 mappings are not applied.

    By default, mappings specified at a location are applicable to all data rules in a location.

15. Click Save.