- User's Guide
- Data and Data Cells
- Working with Drill-Through Reports
- Accessing Drill-Through Reports
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:
-
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.
- From the data source ribbon, select Drill-through.
-
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.
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.
-