Hyperion Financial Data Quality Management Enterprise Edition (FDM EE)
Finance organizations continually enhance the quality of their internal controls and reporting processes. To meet these goals, a source-to-report view of financial data processes is required. Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE)is a solution that allows business analysts to develop standardized financial data management processes and validate data from any source system—all while reducing costs and complexity. FDMEE puts the finance user in total control of the integration process to define source data, create mapping rules to translate data into the required target format, and to execute and manage the periodic data loading process.
Step 1. Import
During import, the source data is loaded into the FDM module and brought into a uniform structure. Both structured data from databases or the ERP system (such as Oracle or SAP) can be directly connected, as well as unstructured information can be imported via flat files. In any case, the original file will remain after the import and all processing steps will be logged in a comprehensible way. The imported data can also be enriched with additional information during this first step.
Step 2. Validate
During the validation process, the data now loaded in the FDM EE are automatically compared with the target system. This not only checks whether all accounts have been assigned to a corresponding target account, but also whether all the required information is available. Missing information can be supplemented by standardized rules
Step 3. Export
The export step loads the data into the target system (such as Hyperion Financial Management or Hyperion Planning), and optionally triggers existing calculation logic in the target system, such as currency conversions or consolidation
Step 4. CHECK
If validation rules exist in the target system, the aggregated or calculated values can be retrieved and checked in the form of check reports.
Hyperion FDMEE Architecture
Oracle Hyperion Financial Data Quality Management, Enterprise Edition is the key application for integrating Enterprise Resource Planning (ERP) systems with Oracle’s Hyperion EPM applications. FDMEE is accessed through Oracle Hyperion Enterprise Performance Management Workspace, which uses Oracle Hyperion Shared Services to authenticate users. The key to its integration lies within its underlying engine, Oracle Data Integrator.
FDMEE sits on top of Oracle Data Integrator and orchestrates the movement of metadata and data into EPM applications. The application server can be deployed on multiple platforms (see the Oracle Hyperion Enterprise Performance Management System Certification Matrix) and connects with EPM applications such as Oracle Hyperion Financial Management, Oracle Hyperion Planning, Profitability, Account Reconciliation Manager, and Oracle Essbase.
The ODI Agent installed and used by FDMEE is exclusively for processes launched as part of FDMEE processing, including the FDMEE user interface, FDMEE batches, or FDMEE jobs executed by way of a Windows or Lynx batch. The FDMEE repository is for exclusive use of FDMEE objects shipped by Oracle, or for castigations made by the customer to these objects. The ODI agent or repository used by FDMEE cannot be used for any other purpose by the customer. Any other ODI work needs to use a separate agent and repository.