將 Oracle Enterprise Data Management Cloud 維度和對映與 EPM Cloud 應用程式同步

此範例案例探討如何在 Oracle Enterprise Data Management Cloud 應用程式與 Oracle Enterprise Performance Management Cloud 應用程式之間同步維度。

您可以使用本節中的指令碼來完成這些任務：

• 從 Oracle Enterprise Data Management Cloud 應用程式匯出維度
• 從 Oracle Enterprise Data Management Cloud 應用程式維度匯出對映
• 將匯出檔案複製到 EPM Cloud 環境
• 將維度中繼資料和對映匯入至 EPM Cloud 應用程式

若要在 Oracle Enterprise Data Management Cloud 應用程式與 EPM Cloud 應用程式之間同步維度和對映，請執行下列動作：

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. 手動執行指令碼，或視需要排定其執行。請參閱自動執行指令碼。