Creating Member Mappings
You use member mappings to identify how source dimensionality translates to target dimensionality based on source values. Member mappings are referenced during the data load, enabling Data Management to determine how to dimensionalize the data that is loaded to the target application. They define relationships between source members and target dimension members within a single dimension. You must create a member mapping for each target dimension.
The five types of member mappings:
-
Explicit—The source value is matched exactly and replaced with the target value.
-
Between—The range of source values is replaced with a single target value.
-
In—Enables a list of non-sequential source values to be mapped to one target value.
-
Multi-Dimension—Enables you to define member mapping based on multiple source column values.
-
Like—The string in the source value is matched and replaced with the target value.
The following table is an example of a member mapping, where three segment members, Cash-101, Cash-102, and Cash-103 map to one EPM member Cash.
Table 4-11 How Segment Members Map to EPM Members
Segment/Chartfield Member | EPM Member |
---|---|
Cash-101 | Cash |
Cash-102 | Cash |
Cash-103 | Cash |
Expense-1 | Expense |
Expense-2 | Expense |
You can use special characters for the source values. See Using Special Characters in the Source Value Expression for Like Mappings and Using Special Characters in the Target Value Expression.
Note:
Target values for multi-dimensional mapping must be an explicit member name. Wildcard or special characters are not supportedTo define member mappings: