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 he 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. For example, synchronizing data enables you to take the data loaded from your General Ledger to Planning, and then transformed into budget information, back to the General Ledger.
Tasks enabled by the data synchronization:
Create and modify synchronizations.
Select source and target applications.
Define mappings between sources and targets.
Copy data from Financial Management to Essbase for reporting purposes.
Copy consolidated data from Financial Management to Planning for future planning.
Copy from one Financial Management application to anotherFinancial Management used for different statutory reporting purposes.
Write data from EPM System to Enterprise Resource Planning (ERP) applications.
Validate synchronizations.
Execute synchronizations.
View logs of synchronization activities.
Data synchronization enables you to create synchronizations between Financial Management, Planning, Profitability and Cost Management, Essbase (ASO), and Essbase (BSO) as destinations, and the following sources:
Financial Management
Planning
Profitability and Cost Management
Essbase (ASO)
Essbase (BSO)
At a high level, the steps to synchronize data in FDMEE 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.