Migrate data from CPM Consolidation to EPM CE

Mauricio Mendoza

Hi Community

Someone knows what is the best way to migrate data from CPM 10.4.7 - Consolidation module to EPM Cloud Edition? I am looking for a technical documentación of how to do it? best practices, etc. I plan to load data from three year ago. What should be the best and easy way to do it? I am trying to have the structure in EPM as close as CPM. I really appreciate your comments and ideas. Thank you.

Regards,

Mauricio   

Vid dEPM-652 - Custom Report.mp4

unknown

Hi Mauricio, I would recommend setting up a reporting cube outside of consolidations to hold the historical data post-consolidation so you don't have to reconsolidate the historical data. You can then set up a feed from EPM Consolidations to the reporting cube and retain reporting flexibility outside of the core consolidation model. How similar is the structure? If you need to perform data transformations you can either do that manually to the exported data in Excel or via a mapping table or transformation script in relational modeling.