FDM Drill Into Anything


Drill-into-Anything is a powerful Enhancement for Oracle’s Hyperion Financial Data Quality Management.  Our custom Source Adapter for Hyperion Financial Data Quality Management, Drill-into-Anything (DIA), enhances and extends the functionality of Oracle’s Hyperion ERP Integrator.

Compare Mindstream DIA vs. Oracle's ERP Integrator

In a recent release, Oracle published a new component called ERP Integrator (ERPI) which can be configured to create a direct connection between FDM and a source GL system (Oracle Financials and PeopleSoft). This can be used in two ways: 

  1. To extract data directly from the source GL system and import it into FDM
  2. To drill back from an aggregated level in FDM into the actual transactions which exist in the Source GL data and further more logon to the source GL system and being directed to the exact transactions which have comprise the value existing in FDM

 Limitations of ERP Integrator

ERPI’s ability to drill into a source GL system is an important step towards the goal of creating Management Excellence. However, it currently has some limitations.  The most critical ones are:

  • Supported Source Systems are limited to most recent versions of E-Business Suite and PeopleSoft.
  • Import Formats: restricted capabilities (concatenation of Entity dimension); multiple Import Formats required
  • Complexity: multiple tools and configuration steps required
  • High Licensing fees

Comparison of ERPI and MindStream’s DIA

Function

ERP Integrator

FDM Drill-Into-Anything

Drill back launches GL system

Yes (requires configuration)

Not without customization

Supported Source Systems

Oracle Financials (selected versions after 11.5.10 cu2); PeopleSoft (?)

Any relational source system (no known limitations)

Implementation

Pre-built solution, mapping of pre-defined Source data file to FDM Import Format, additional Import Format

Based on integration Templates, slight modification of Import Format

Required components

Oracle Data Integrator (ODI), ERPI Integrator, Hyperion Workspace

FDM “Drill-into-Anything” patch (2 file changes, Java Servlets); Workspace or Web Application server for Java Servlets

Configuration Effort

ODI Topology, ERPI connectivity, Metadata Rules, Data Rules, FDM adapter (1 adapter per Set of Books)

FDM adapter (1 adapter for all Sets of Books, Location settings), Infrastructure to connect from FDM to Source Database

Implementation Time

4 weeks

4 weeks

Complexity to understand

High(ODI/ERPI/Drill back configuration, requires 2 Import Formats with limited capabilities)

Low (Definition and assignment of views, 1 Import Format with full capability)

Number of Database Schemas

3

1

Supported by

Oracle

MindStream Analytics

Security

Shared Services AND FDM

FDM only

Licensing

Additional license required (around $2900 per user???)

None (implementation and support as T&M)

Known Issues

FDM Import Formats not supported; only certain Versions of certain GL systems are supported

Full support of FDM Import Formats; no restrictions to

 

 

About Us


MindStream Analytics is a leading consulting firm focused on helping clients improve business understanding and decision making. With years of experience in the analytics and Business Performance Management area, MindStream offers customers services ranging from software selection and implementation to best practices for financial planning.

 MindStream will work with customers towards a solution that enhances value and offers more insight into their data. MindStream believes in the power of technology combined with new procedures to give customers better analytic capabilities.

Learn More about how Drill into Anything can help you!