1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Defining Data Maps
  3. Moving Data
  4. Moving Data from One Cube to Another Cube Using Smart Push
  5. Using a Cross Application Smart Push

Using a Cross Application Smart Push

The Cross Application Smart Push feature enables customers with multiple environments to instantly transfer data, cell comments and supporting detail from a Planning cube in a source environment to a reporting or other Planning cube in a remote environment while working in forms.

Note:

Cross application data maps are supported only for smart pushes. The data map push for cross applications will be supported in a future update.

Note:

The Cross Application Smart Push feature is not available for Strategic Modeling.

Note:

Transfer of attachments using Smart Push is supported only for same environment data maps.

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

  1. Create a new Oracle Enterprise Performance Management Cloud 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 EPM Cloud 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.

  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. Open a form and add the Smart Push to the form.

    For more information, see Configuring Smart Push for a Form.