Using Detailed Member-Level Mapping
You use detail member-level mapping to include selected members of a dimension while moving data from one cube to another cube when working with exceptions. That is, member-level mappings do not need to be defined when source and target members are the same or do not require any roll-up member mappings or transformations. Including detail member-level mapping while moving data is useful when you need to define complex mappings to or from multiple dimensions or from a single dimension between members with different names. Mapping is required when the members in the source cube do not match the members in the Target cube.
Detail member-level mappings include:
- Simple Mappings: One to One mappings between source and target members
- Roll-up Mappings: Multiple members on a source to a single target member
-
Multi-Dimension Mapping: Multiple dimensions mapping enables you to map two source dimensions to one target dimension or one source dimension to two target dimensions.
- Substitution Variable Mapping: Select a Substitution Variable so that it is referred and picked-up during the Data Push/Smart Push instead of explicitly mapping a dimension member in the source.
To perform a detailed member-level mapping:
-
From the Data Maps home page, click the name of the data map to which to define a detailed mapping.
-
From the Detail page, select the dimension to which to add the detailed mappings.
-
Click Map for the dimension to add the mappings.
-
On the Edit Data Map page, select the source member(s) to map to the target member.
If the source members are different than the target members, the source members may be shown. If they are not shown, use the Populate Detailed Mapping feature, or select each member to map by clicking the arrow drop-down in Source and selecting each member.
-
To add a source member, double-click the Source selection arrow (
), and select the source member to map.
-
To add a target member, double-click the Target selection arrow (
), and select the target member to map.
If you are using a different (cross) application, under Target, and then from the Cube drop-down, select Select Remote Cube. For more information, see Using a Cross Application Smart Push or .
Additional options include:
-
To add a mapping definition (row) between a source and target members, click
.
-
To delete a mapping row, select the row and click
.
-
To copy a mapping row, select the row to be copied and click
.
-
To paste a mapping row, click
.
-
To delete invalid entries, click
.
-
To populate detailed mappings, click
.
For information, see (see Populating Detail Mappings.
-
-
Optional: Specify an operator if needed.
The operator for a row defines the operation to use for the current row.
If you want to subtract some of the members, then change the operator to a -.
By default, the + operator for each row defines the aggregation.
-
Click Done.