ERPi Functionality

Eldred Smikle

November 15th, 2010

In June 2009, the buzz in the financial services industry was about the new module in the Hyperion Workspace called Enterprise Resource Planning Integrator (or ERPi). ERPi is a component of FDM that allows users to integrate metadata and data from an Enterprise Resource Planning (ERP) source system into an Enterprise Performance Management (EPM) target application. It’s used in conjunction with ODI and supports drill-through, from EPM applications, to the supported source systems.

The new features, of ERPi, already seem to be in high demand. The drill through capability from EPM applications to ERP systems, such PeopleSoft and Oracle E-Business Suite, is very compelling. Once ERPi is up and running, financial analysts can easily chart the path for metadata and data all the way from the target system back to the source of the transaction. Streamlining a cumbersome process and freeing up time for analysts to do more in-depth analysis.

The one caveat to the new ERPi release is it is only compatible with an Oracle database. This version doesn’t support Oracle RAC, Microsoft SQL Server, or IBM DB2. Now that ERPi has been released, we have realized that the current version is only compatible with an Oracle database. This support makes the ERPi functionality available only to users whose applications are running on Oracle. However, the next release of ERPi is supposed to encompass a wider range of Relation Database Management Systems. The promised release date was Q4 2010, but it has now shifted out to Q1 2011. For everyone not running an Oracle Instance, stay tuned. You will definitely want to take advantage of ERPi as soon as it’s available.

Eldred Smikle

About Eldred Smikle

Eldred Smikle is the Technical Services Manager for TopDown Consulting. He has over 15 years experience working with Oracle Hyperion Enterprise applications. He specializes in product infrastructure installation and configuration for all Hyperion products. He has worked with a broad base of operating system platforms, relational databases, and Java application servers Microsoft SQL, Oracle, Apache Tomcat, IBM Websphere, BEA Weblogic, and Oracle 10g. A frequent contributor to, Eldred also serves as the publications Oracle Hyperion expert when it comes to reader questions.

6 comments on “ERPi Functionality”

  1. Find and select some good points from you and it helps me to solve a problem, thanks.

    – Henry

    1. Eldred says:

      Thanks Henry… Please feel free to share any new points you find on the subject..

  2. Manny says:

    Our version of EBS is 11.5.9 will ERPI work in this version?

  3. Maitreyee says:

    Is there any way to automate execution of metadata rule?

Leave a Reply

Your email address will not be published. Required fields are marked *