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.