1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Drill Through
  3. Creating a Drill-Down for the EPM Integration Agent

Creating a Drill-Down for the EPM Integration 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 Oracle Enterprise Performance Management Cloud. You can perform two types of drill depending on the availability of a landing page:

  1. If the source system provides a landing page that displays the detail source data, you access the landing page using an http URL and passing contextual parameters to this page. To use this method, you define a http drill URL similar to other source integrations on the Map Dimensions page and use the substitution variables to pass the URL parameters. .

  2. If the source system does not provide a landing page to view the detail source data, execute an SQL query in the source database and display the results in a pop-up window inside Data Integration using the EPM Integration Agent. To use this method, you need a web server running in https mode. The web server accepts the drill request and routes it to the agent. For more information, see Creating a Drill Down to a Source System Without a Landing Page.

Additional Considerations:

  • Available for SYNC and ASYNC mode s
  • HTTPS server required
  • If inside network, open port not required
  • Oracle Smart View for Office drill inside network doesn’t require an HTTPS server.
  • drill from public internet outside of network does require a public facing HTTPS server/port
  • Configure re-write rules to redirect drill request to Agent URL.
  • Test with https://<server>/epmagent/rest/details