Using Drilling Through

Data Management provides a framework that enables you to drill through from your Oracle Fusion Cloud Enterprise Performance Management application to the application. Use drill through when you want to understand the source of a data value, or you need a granular level of detail for a value without leaving the workspace.

When you load data to a Cloud EPM target application using Data Management, you can specify an optional drill region flag. When set to "Yes," a drill region definition is passed to the target application, in addition to the actual data, to indicate that a cell is "drillable."

When drilling through from the Cloud EPM application, a landing page is displayed in a separate workspace tab that shows all rows that comprise the amount from the selected cell in the Cloud EPM application. From this landing page, you can open the source document or continue to drill-through to the defined source system landing page.

Drill through based on a URL requires that you are connected to the server on which the data resides. Drill through works only for data loaded through Data Management. In addition, because drill through is available in the target application, data load mappings must have at least one explicit mapping for the drill through to work.

Note:

Drill through functionality is not supported for exchange rates data loaded to:
  • Financial Consolidation and Close
  • Tax Reporting
  • Planning Modules
  • Planning