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. Select a data cell associated with a drill-through report.

   Oracle Analytics Cloud - Essbase: 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.

2. From the data source ribbon, select Drill-through.
3. 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 or Data Management 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.