Accessing Drill-Through Reports

Depending on your data source connection, you can drill through to web pages or Excel sheets.

To access a drill-through report:

1. Before you begin: If you plan to perform drill-through to a web page, first open the default browser and log in to the target web application.

   For example, launch Planning and log in. You must have the application running in the browser before logging in to Smart View.

2. Select a data cell associated with a drill-through report.

   Oracle Essbase cloud: You can select multiple cells for drill-through to relational data in Excel sheets.

   Tip:

   If you want to display a list of available drill-through reports whenever you mouse over a cell, select Display Drill-Through Report ToolTips on the Advanced page of the Options dialog box.

3. From the data source ribbon, select Drill-through.
4. If there are multiple drill-through reports associated with the cell, select a report from the list and click Launch.

   If only one drill-through report is associated with the cell, the drill-through report launches directly.

   Note:

   Oracle Enterprise Performance Management Cloud:

   • If connected to a supported EPM Cloud service and using Data Integration to load data for drill-through reports, the report is launched according to the selection you made in Setting the Drill-Through Launch Option.

   • The first time that you click a drill-through cell and the browser launches, you may be asked to log in to your cloud service and the drill-through report may not be displayed as expected. You can return to the sheet in Oracle Smart View for Office and click the drill-through cell again to launch the drill-through report. Or, to avoid this error, you may sign in to the business process in the browser first, before launching drill-through from Smart View.