Synchronizing Cloud EPM Dimensions with Cloud EDM Applications

This sample scenario explores synchronizing a dimension between an Oracle Fusion Cloud Enterprise Performance Management application and an Oracle Fusion Cloud Enterprise Data Management application.

You use the scripts in this section to complete these tasks:

  • Export metadata (dimensions) from a Cloud EPM application
  • Copy the export files containing dimension data to an Cloud EDM environment
  • Import dimension metadata into the Cloud EDM application

To synchronize a dimension between a Cloud EPM application and an Cloud EDM application:

  1. Create a Windows script file by copying the following script:
    rem Integration example to sync an application dimension between Cloud EPM and Cloud EDM
    rem Windows script for demonstration purposes only; do not use in production environments
    
    set EDMUSER=userid
    set EDMSVR=https://hostname
    set EDMPWDFILE=example_EDM.epw
    set EDMAPP=appname
    set EDMDIM=dimname
    
    set EPMUSER=userid
    set EPMSVR=https://hostname
    set PWDFILE=example_epm.epw
    set EPMEXPJOB=exportjobname
    
    rem Synchronizing EPM ---> EDM
    
    rem Export Metadata from EPM
    call epmautomate login %EPMUSER% %PWDFILE% %EPMSVR%
    call epmautomate exportmetadata %EPMEXPJOB%
    call epmautomate logout
    
    rem Import Dimension to EDM
    rem Log into the EDM environment
    call epmautomate login %EDMUSER% %EDMPWDFILE% %EDMSVR%
    rem Copy exported metadata file into the EDM environment
    call epmautomate copyfilefrominstance %EPMEXPJOB%.zip %EPMUSER% %PWDFILE% %EPMSVR% %EPMEXPJOB%.zip
    call epmautomate importdimension %EDMAPP% %EDMDIM% ReplaceNodes %EPMEXPJOB%.zip
    call epmautomate logout

    Modify the script file and set the required parameter values. See Parameters for Script Execution for explanation and example of the parameters.

  2. Run the script manually or schedule it to run as needed. See Automating Script Execution.