FDMEE - The future of Hyperion Integrations
Guest Post by
Manav Anand, EPM Consultant
FDMEE stands for Financial Data Quality Management, Enterprise Edition, introduced in the latest EPM release, 220.127.116.11. It is the latest version of Oracle's Financial Data Quality Management. It is a data integration tool majorly used for integrating financial data.
It is one of the favorite tools for business users and administrators because of its user friendly web interface and audit capabilities. A major advantage of using this tool is the drill through capability to Oracle GL and various other source systems which includes Oracle Fusion Financials, PeopleSoft, SAP ERP Financial to name few. This tool is a seamless integration of ERPi and FDM. It is based on the ODI engine with the FDM workflow. The tool was released in a phased approach and targets to cover all the FDM functionalities by the end of last patch.
I would like to introduce the functionalities of this application based on our implementation experience in this blog.
The basic release of FDMEE covered the below mentioned functionalities:
1. Core FDM features
2. FDM Workflow - Import, Validate, Export and Check
3. Partial HFM adapter parity - Data Protection and Line item details
4. Drill through to source
5. Open Batch Loader
7. Process Monitor
In addition to above mentioned functionalities, following features are added to core FDM features in FDMEE:
1. FDMEE is accessible from Workspace directly
2. ODI is installed and configured automatically
3. Adapters are configured with in the ODI
4. An added functionality of Data load rule to define the Source filter options
5. Scripting supported in Jython
6. Batch processing natively supported via ODI
7. Shell scripts supported to run for lights out automation
8. A central process monitoring for all the FDMEE processes
Following are some of the gaps in the current version of FDMEE. Some of these are planned to be addressed in the upcoming patch 2 while a few others will be addressed in later releases.
1. Control Process
2. Multi Load
3. Custom Scripts
4. Tab delimiter
5. No options to save UI settings in Workbench
6. LCM Issues - While importing the backup, Import for Data load rules and Application Period mappings fail
7. No Object for Period Name for scripting
Apart from these changes following features have been excluded from FDMEE:
1. Tax adapter
2. Enterprise adapter
3. Currencies in Control Tables
I will follow up with some more details on the above mentioned functionalities where I will use our implementation experience to call out some items you might want to watch out for while designing EPM landscape which leverages FDMEE for integrations and data quality management purposes.