Using Drilling Through to Source

Data Integration provides a framework that enables you to drill through from your target application to the source 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.

These are the flavors of drill through supported in Data Integration :

  1. Standard Mode—In this mode you drill from Oracle Fusion Cloud Enterprise Performance Management data form to a landing page and then drill to the source system data. Using this method, you must load data using Data Integration. You must use the Full Workflow mode, which is supported for all business service types. For this mode you can use the auto-created drill region or custom drill region.

  2. Direct Drill—In this mode, you drill through directly from any platform-based form to source data, which can be queried and launched using an external URL or an EPM Integration Agent query.

    In this case, you can load the data using Full Workflow mode, Quick mode or even load directly to the Cloud EPM business process. This mode is not supported for Account Reconciliation and Profitability and Cost Management business processes. For this mode you must define a custom drill region.

    For more information, see Defining Direct Drill.

Three types of URL are supported in drill through

  1. Landing Page—The landing page URL Type enables you to drill from Cloud EPM data form to a landing page and then drill to the source system data. Using this method, you must load data using Data Integration. You must use the Full Workflow mode, which is supported for all business service types. For this mode you can use the auto-created drill region or custom drill region.

  2. Custom URL or Deeplink—Use a URL associated with a custom direct drill region definition and display the drill through results in a separate browser

  3. Agent—When integrating to an on-premises data source, you can drill down to the source to view the details associated with account balance data loaded to the Cloud EPM

For more information about drill through, see: Drilling Through to Source Systems in Cloud EPM.