In Oracle Cloud EPM, which step is required to set up a drill-through link to an external data source?

To establish a functional drill-through link to an external source system in Oracle Cloud EPM Data Integration, administrators must configure the specific connection details for the source system. This setup includes defining connection parameters, source URL parameters, server details, and authentication settings required to direct the user from EPM target intersections back to the source records. Without proper connection configuration, the system cannot construct valid target-to-source landing page URLs or execute web service calls to external databases. Properly configured connection details ensure secure, accurate parameter passing between the EPM Cloud environment and external ERP systems during drill-through execution, enabling seamless context-aware navigation across enterprise financial applications.

Option A: Scheduling recurring data loads automates data synchronization tasks but does not establish the connectivity parameters needed for drill-through navigation.

Option B: Setting up custom reporting templates controls report layout and formatting rather than establishing external system connectivity and drill URLs.

Option C: Defining manual data transformation rules maps metadata and dimensions during data load, but does not configure external source system drill-through links.

1. Oracle Corporation, "Administering Data Integration for Oracle Enterprise Performance Management Cloud," Section: "Configuring Source Connection Details".

2. Oracle Cloud EPM Documentation, "Setting Up Target and Source Connections for Integration", Chapter 3: "Managing Connections".

3. Oracle Enterprise Performance Management System Architecture Guide, "Integrating External Data Sources via Web Services and URL Landing Pages".