Data synchronization enables you to synchronize and map data between EPM source to target applications irrespective of the dimensionality of the application simply by selecting the source and target EPM application, and then mapping the data. Given the powerful mapping features already available, the data can be easily transformed from one application to another application.
Tasks enabled by the data synchronization:
Create and modify synchronizations.
Select source and target applications.
Define mappings between sources and targets.
Copy data from Oracle Hyperion Financial Management to Oracle Essbase for reporting purposes.
Copy consolidated data from Financial Management to Oracle Hyperion Planning for future planning.
Copy from one Financial Management application to another Financial Management used for different statutory reporting purposes.
Write data from Oracle Enterprise Performance Management System to Enterprise Resource Planning (ERP) applications.
Validate synchronizations.
Execute synchronizations.
View logs of synchronization activities.
At a high level, the steps to synchronize data in Oracle Hyperion Financial Data Quality Management, Enterprise Edition include:
Import Format—Select the source and target EPM System applications.
The dimensional mapping is also defined in the import format. You map the dimensions that comprise each source and target application so that the synchronization can recognize all relevant elements.
Data Load Rule—Define the source filter parameters.
Execute—When the data rule is executed, data from the source EPM System is extracted to a file. The data can be imported and processed using the data load workflow process.
Export—Synchronizes the data.