Tuesday, February 22, 2022

Oracle Cloud EPM : How to Export and Import Period mapping in Data management / Data exchange

NEW FEATURE

As we all know that using epm cloud data management we cannot export and import the period mapping, we need to manually add the periods in the Global mapping by referencing the prior period key and the period key and then define the application and source mapping accordingly.

But now the "DATA EXCHANGE" feature in Oracle EPM Cloud FCCS / PBCS / EPBCS has an option to add periods using excel. 
We can export the current mapping and then we can add our required mapping and then import the file back to data exchange which in turn gets updated to the Global mapping in data management.

STEPS

Go to Navigate > Data exchange 
Click on Actions > Period Mapping 
    Here you can import, export, delete period mappings 




No comments:

Post a Comment

Other posts

How is the data size calculated for a EPM Cloud service instance?

The total size of data used by your EPM Cloud service instance is the sum of the following: Application data stored in Essbase Artifact...