Call Us: 1-800-497-0151

Drill into Anything Vs Oracle Hyperion's ERP Integrator


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:

  • To extract data directly from the source GL system and import it into FDM
  • 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 Drill-into-Anything


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)


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



Supported by


MindStream Analytics


Shared Services AND FDM

FDM only


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

Contact MindStream Analytics

Want to know more about DIAvsERPI? Fill out the form below.

Partner SpotLight

Oracle Partner


Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost