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.

    Oracle Enterprise Performance Management Cloud: If connected to a supported EPM 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.