Defining a Roll-up Mapping
When you need to map multiple source members to a single target member, use roll up mappings to aggregate the selected source members to the target member. For example, to have multiple accounts from the source aggregate and map to a single account in the target, add a row for each member in the source, and map each to the same target member.
To use roll-up mappings:
-
From the Data Maps home page, click the name of the data map to which to define a roll-up detailed mapping.
-
From the Detail page, select the dimension to which to add the roll-up mappings.
-
Click Map for the dimension to add the mappings.
-
On the Edit Data Map page, select the source member(s) to roll up 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.
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.
In the following example, source members "110" and "111" are rolled-up mappings to the target member "120."