Overview of FDM

Oracle Hyperion Financial Data Quality Management, Fusion Edition (FDM) is an out-of-the-box data transformation tool that feeds source-level financial data to consolidation, reporting, planning, and analytical applications. More than a data translation tool, it provides these capabilities:

FDM provides a uniform data collection process for all reporting units within an organization. FDM also contains financial control functionality that assists with internal financial control processes. FDM features adapters that enable it to integrate with Oracle's Hyperion® Enterprise® , Oracle Hyperion Financial Management, Fusion Edition (Financial Management), Oracle Essbase (Essbase), and Oracle Hyperion Planning, Fusion Edition (Planning). However, FDM can also be used to load data into other financial consolidation and analytical applications.

The basic FDM process includes six steps:

  1. Import source data

  2. Validate source data against mapping tables

  3. Export source data to a target system

  4. Consolidate target system data

  5. Validate target system data

  6. Review and validate internal financial control

The figure shows OLE DB, ODBC, flat files, and Excel as a source , FDM as the consolidation tool, and Essbase, Financial Management, Enterprise, any OLAP application, and SQL Server/Oracle/DB2 databases as target systems.