1. Administering Data Integration for Oracle Enterprise Performance Management Cloud Learning Path
  2. Perform a Load that Includes Multiple Accounts in Columns with Numeric Data
  3. Enter Mapping Rules

Enter Mapping Rules

After the dimension mapping is complete, the next step is to enter mapping rules for all the dimensions except HSP_View and Amount. For this integration, we will use simple wild card mappings. Wild card mappings are fine for low volume integrations, but do not perform well for large data sets. (The HSP_View and Amount dimensions use the target and source expressions we set up when we mapped the dimensions instead of the wild card mappings.)

For each dimension (except HSP_View and Amount) we will enter * as the source, * as the target, and a processing sequence. As a standard practice, it is recommended to enter a different sequence for each rule.

For each dimension (except HSP_View) we will enter * as the source, * as the target, and a processing sequence. As a standard practice, it is recommended to enter a different sequence for each rule.

  1. With the Account dimension selected, click Add button (Add button) to add a new mapping rule.


    Edit Integration screen with Account and the Add button selected

  2. In Add Member Mapping, enter * as the Source, * as the Target, and 10 and the Processing Order, and then click OK.


    Add Member Mapping screen with * as the Source, * as the Target, and 10 as the Processing Order

  3. Select the drop-down to change the dimension to Data, and then click Add button(Add button) to add a new mapping rule.


    Edit Integration screen with Data and the Add button selected

  4. In Add Member Mapping, enter * as the Source, * as the Target, and 20 and the Processing Order, and then click OK.


    Add Member Mapping screen with * as the Source, * as the Target, and 20 as the Processing Order

  5. Select the drop-down to change the dimension to Entity, and then click Add button(Add button) to add a new mapping rule.


    Edit Integration screen with Entity and the Add button selected

  6. In Add Member Mapping, enter * as the Source, * as the Target, and 30 and the Processing Order, and then click OK.


    Add Member Mapping screen with * as the Source, * as the Target, and 30 as the Processing Order

  7. Select the drop-down to change the dimension to Product, and then click Add button(Add button) to add a new mapping rule.


    Edit Integration screen with Product and the Add button selected

  8. In Add Member Mapping, enter * as the Source, * as the Target, and 40 and the Processing Order, and then click OK.


    Add Member Mapping screen with * as the Source, * as the Target, and 40 as the Processing Order

  9. Select the drop-down to change the dimension to Version, and then click Add button(Add button) to add a new mapping rule.


    Edit Integration screen with Version and the Add button selected

  10. In Add Member Mapping, enter * as the Source, * as the Target, and 50 and the Processing Order, and then click OK.


    Add Member Mapping screen with * as the Source, * as the Target, and 50 as the Processing Order

  11. Click Save and Continue to proceed to the next step in defining the integration.


    Edit Integration screen with Save and Continue selected