将 Oracle Enterprise Data Management Cloud 维和映射与 EPM 云应用程序同步

此示例方案介绍了在 Oracle Enterprise Data Management Cloud 应用程序和 Oracle Enterprise Performance Management Cloud 应用程序之间同步维。

使用本节中的脚本可完成以下任务：

• 从 Oracle Enterprise Data Management Cloud 应用程序中导出维
• 从 Oracle Enterprise Data Management Cloud 应用程序维中导出映射
• 将导出文件复制到 EPM 云环境
• 将维元数据和映射导入到 EPM 云应用程序

要在 Oracle Enterprise Data Management Cloud 应用程序与 EPM 云应用程序之间同步维和映射：

1. 通过复制以下脚本来创建脚本文件：

   rem Integration example to sync application dimensions between EDM and EPM Cloud
   rem Windows script for demonstration purposes only; do not use in production environments
   
   set EDMUSER=userid
   set EDMSVR=https://hostname
   set EDMPWDFILE=example_EDM
   set EDMAPP=appname
   set EDMDIM=dimname
   set EDMLOC=location
   
   set EPMUSER=userid
   set EPMSVR=https://hostname
   set EPMIMPJOB=importjobname
   set PWDFILE=C:\Oracle\EPM.epw
   set DIMFILE=dimension.csv
   set MAPFILE=mapping.csv
   
   rem Synchronizing EDM ---> EPM
   rem Export Dimension and Mappings from EDM
   
   call epmautomate login %EDMUSER% %EDMPWDFILE% %EDMSVR%
   call epmautomate exportdimension %EDMAPP% %EDMDIM% %DIMFILE%
   call epmautomate exportdimensionmapping %EDMAPP% %EDMDIM% %EDMLOC% %MAPFILE%
   call epmautomate logout
   
   rem Log into the EPM Cloud environment
   call epmautomate login %EPMUSER% %PWDFILE% %EPMSVR%
   
   rem Copy exported files from EDM environment to EPM and import metadata and mappings
   call epmautomate copyfilefrominstance %DIMFILE% %EDMUSER% %EDMPWDFILE% %EDMSVR% inbox/%DIMFILE%
   call epmautomate importmetadata %EPMIMPJOB%
   
   call epmautomate copyfilefrominstance %MAPFILE% %EDMUSER% %EDMPWDFILE% %EDMSVR% inbox/%MAPFILE%
   call epmautomate importmapping %EDMDIM% %MAPFILE% REPLACE FALSE %EDMLOC%
   
   call epmautomate logout

2. 修改脚本文件并设置所需的参数值。有关参数的说明和示例，请参阅“脚本执行的参数”。
3. 手动运行脚本或调度该脚本以根据需要运行。请参阅“自动执行脚本”。