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

Drill Through to Source Using the EPM Integration Agent

Drill through to source using the EPM Integration Agent is supported irrespective of how the EPM Integration Agent is configured for the asynchronous or synchronous mode option.

When using web forms and you drill through to source using the EPM Integration Agent, the browser invokes the agent passing the query and other parameters using the HTTP protocol. The agent processes the query request and returns the data to the browser to be displayed to the user. The browser session to the Oracle Enterprise Performance Management Cloud uses the HTTPS protocol so the communication from the browser to the agent uses HTTPS.

Browsers do not allow mixed HTTP and HTTPS connections in the same session. In order to support drill, perform the following configuration steps:

  1. Install and configure an HTTPS web sever inside the on-premises network.

  2. Configure the rewrite rules in the web server to redirect the request for drill to the Agent URL (same as in the synchronous agent definition. See Configuring Synchronous Mode).

  3. Configure the Web URL of the agent to point to the HTTPS web server.

  4. Optional: To test your agent drill-through setup, use the following URL to make sure that your webserver re-write rules are defined correctly: https://server/epmagent/rest/details.

    When testing the setup, replace "server" with the web url that is defined in your agent setup.

    Image shows the Drill to Source in the EPM Integration Agent.

Note:

In the above configuration, the drill is supported only when the client computer running the browser is inside the on-premises network. If you want the drill to be available even when the browser is not in an internal network, enable the HTTPS web server to be publicly accessible.

Note:

When using Smart View and you perform a drill through to source, the additional HTTPS web server configuration is not required. In Smart View, set the drill through launch to open in a new sheet.