Five Steps for Effective Drill-through
Posted by Ed Abad on Thu, Dec 10, 2009
Imagine this, you are in Microsoft Excel and looking at the P&L for the last
month and some numbers look odd. Where to go next? More often than not you will then open a session to your general ledger system (Peoplesoft, Oracle E-Business Suite, etc.) to research the numbers. You are not alone, in fact we recently surveyed a Fortune 1000 company and discovered 9 out of 10 analysts would want to drill back to the source general ledger system.
To mitigate this pain, Oracle has made a conscious effort have the drill through seamless to the end user.
Oracle has released a new module to the Hyperion Workspace, called Enterprise Resource Planning Integrator (or ERPi).
Before you jump into the research on what ERPi is and what can it do for you, here are five winning steps to consider when making the decision to drill back from the Hyperion environment to your general ledger system.
1) Determine that in fact your Hyperion user base has the need to drill back to the general ledger system. Do your users find it difficult to drill through today? As like any finance related project, getting buy in from the user community will ensure project success in the future.
2) Where do your users drill back from? Is it from a Microsoft Excel Essbase Connection, Hyperion Financial Report and/or Planning Web Form? If you answered yes to these you are definitely ready for EPRi.
3) Ensure you have or planning to install Hyperion EPM version 11.1.1.3. EPRi is a module that requires an 11.1.1.3 environment.
4) Do you have the right ERP systems? ERPi currently supports certain versions of Oracle and Peoplesoft (see whitepaper for more details) with SAP scheduled next year.
5) Once you get through the technical hurdles, now comes the implementation. Do you have the right people on finance team to implement an ERPi project? Should you seek expertise outside your organization/company? These are all valid questions, and probably the most difficult to answer. To aid with your decision, the whitepaper below has more details on ERPi and its implementation.
To learn more, download our whitepaper on the FAQ surrounding the EPRi module now.