Moving Data Using a Cross Application Data Map

For data maps with member(s) mapping and data can be pushed to a remote target environment.

To transfer data, cell comments, and supporting from a source cube to a remote reporting cube:

  1. Create a new Oracle Fusion Cloud Enterprise Performance Management connection if it's not available to the cross application where the data has to be moved.

    For more information, see Creating, Editing, and Deleting Connections to Other Cloud EPM Environments in Administering Planning.

  2. Create the reporting application.

    For information on cubes, see Managing Cubes in Administering Planning. For information on adding members, see Editing Dimension Properties in the Simplified Dimension Editor in Administering Planning.

  3. Click Application then Data Exchange, and then click Data Maps.

  4. Click Create.

  5. Under Source, select a cube from the available cubes for the current application.

  6. Under Target and from the Cube drop-down, choose Select Remote Cube.

  7. From the Select Remote Cube page, select the connection and cube for the target application and then click OK.

    • Under Connection, select the connection to use to connect to the target cube.

    • Under Cube, select the cube from the remote application.

      All the available connections in the source application are displayed. The cubes from the remote application are displayed based on the selected connection.

  8. Click OK.

    The system displays the message: "Loading dimensions in the target cube."

  9. Map any source members with their corresponding target members when member names differ in the source and target applications. For more information, see Changing Mapping Information for a Dimension.

  10. On the Detail page, click Save and Close.

  11. On the Data Maps listing page, select the data map job to push to the cross application and then from the Actions menu, select Push Data.

  12. When prompted with the message: Do you want to clear the date before push?, select either Yes or No to clear the target cube.

    Note:

    In the case of one to multi-dimension mapping, the data map should be configured with the target selection to clear data. Otherwise the data push fails.

    The Cross Application Data Maps job is displayed in the Jobs console. If an error occurs, click the error link to troubleshoot the problem. If the data is moved, the Run Status displays either as Complete or Completed with Warnings. Click the job name to review the log for further details.