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 Essbase on-premises only: If required, enter a user name and password. The user name and password fields are displayed only if required to access the drill-through report. If a user name and password are not required, then these fields are not displayed.

   Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting:

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

   • If Internet Explorer is your default browser, then the first time that you click a drill-through cell and the browser launches, you will be asked to log in to your cloud service. After login, you may see an HTTP 403 or 500 error. Return to the sheet in Oracle Smart View for Office and click the drill-through cell again to launch the drill-through report.