Drill into Anything Vs Oracle Hyperion's ERP Integrator
FDM
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
|
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 |
Contact MindStream Analytics
Want to know more about DIAvsERPI? Fill out the form below.
Partner SpotLight
Oracle
Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost