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: