Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Infosys at Oracle Partner Network Exchange 2013 | Main | Oracle Fusion Portfolio Management on Cloud »

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, 11.1.2.3. 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
6. Reports
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.


Comments

Great first blog on FDMEE. Looking forward to the next posts.

very good blog

Is it correct to conclude that the current version of FDMEE encomposes the full functions of ODI? In other words, I should be able to replace an ODI implementation with FDMEE without any problems.

Currently features like flexibilty in automation, scheduling and tablespace access are missing in FDMEE. We have the new version available now with great enhancements.
My next blog will cover some of those functionalities.

This is what i was looking for. Thanks!

Thanks for sharing these information. It’s a very nice topic.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles