Welcome to the Strafford Blog

Welcome to the Strafford Blog

Should You Drill back to Your Source Data from Hyperion Planning

Posted by Deborah Jelley

Mar 2, 2015 2:32:12 PM


You know you want to.

Where did that $5,000 come from last month? What, you ask yourself, are the details behind that number you see before you on the web template? It’s something you need to know. It gnaws at you. Your finger is poised over your mouse or track pad. Your analysis would be that much more comprehensive and accurate if you understood all the details. You exhale and double-click on the link. You’ve done it… In Hyperion Planning, you’re drilling back to the source system against that number and its Point of View.

So what is drill back and how does it work? 

Drilling back is different from drilling down. Drilling down is the ability to navigate from the parent member down to the lowest level child member in a rollup or hierarchy. Drilling back allows you to drill back from your Hyperion Planning application to the source system, a GL system for example, where the data came from, using the exact point of view that delivered the number to your screen. No retyping of the Cost center or Unit, account code, year, month, Department, etc. This ability can prove useful in a couple ways: 

  • If the number is made up of several different transactions or consolidated accounts from different subsidiaries, you will have your answer without having to send emails or make that dreaded phone call to the other analyst. And you know the phone call won’t be returned fast enough for you – especially if the analyst is in another country. 
  • You can get down to the transaction level right at the source system.

Oracle’s Hyperion Planning and budgeting module offers the opportunity for you to set up this feature for your finance department and other curious users. Hyperion’s Financial Data Quality Management Enterprise Edition (FDMEE) provides the framework to drill through from the Enterprise Performance Management (EPM) applications back to the general ledger source. Drill through is not supported for human resource data. Users can drill through to detail in the source system through FDMEE from the following products:


In Smart View and Financial Reporting, users can drill through only if the data source is Hyperion Financial Management, Hyperion Planning, or Essbase.

When you drill through, if data was loaded by FDMEE, a landing page is displayed in a new EPM Workspace tab or a new window. The landing page is a gateway to the data in the source system. 

When would it make sense to set up and use drill-back?

Notice above we mentioned that you can drill-back from Financial Reporting? That means you can distribute a report to an end-user, who may not be in the finance department, and they can drill-back to see what made up that number directly from the report without having to log them directly onto the source system. This is accomplished by housing the source date in FDMEE and having the end-users interact with the data there. 

Of course, you can drill back to the source system directly from the landing page through FDMEE – and that would require proper security credentials to this source system – and we typically see finance users set up with that feature. Having the ability to perform their own investigations really helps streamline and speed up both the close and planning processes for finance people. 

To investigate whether drill-back is right for you and your organization, please contact Strafford and we’ll be happy to talk it through with you. If you are interested in migrating your on-premises Hyperion Planning tool to Oracle PBCS (or EPBCS), we can help with that too. We've helped hundreds of finance modernize and automate their finance ecosystem.

How Can we Help You? 

Topics: Budgeting and Forecasting, Financial Reporting, Hyperion Planning, Oracle PBCS