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:

  1. From the Data Maps home page, click the name of the data map to which to define a detailed mapping.

  2. From the Detail page, select the dimension to which to add the detailed mappings.

  3. Click Map for the dimension to add the mappings.

  4. 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.

    1. To add a source member, double-click the Source selection arrow (Image shows an arrow down icon.), and select the source member to map.

    2. To add a target member, double-click the Target selection arrow (Image shows an arrow down icon.), 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 Image shows the Insert icon..

    • To delete a mapping row, select the row and click Image shows the Delete icon..

    • To copy a mapping row, select the row to be copied and click Image shows the Copy icon..

    • To paste a mapping row, click Image shows the Paste icon..

    • To delete invalid entries, click Image shows the Delete Invalid Entries icon..

    • To populate detailed mappings, click Image shows the Populate Detailed Mappings icon..

      For information, see (see Populating Detail Mappings.

  5. 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.

  6. Click Done.