1. Working with Oracle Smart View for Office
  2. Data and Data Cells
  3. Drill-Through Reports

Drill-Through Reports

Predefined by administrators, drill-through reports are available to users from specified individual data cells.

Data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud

A cell can be associated with multiple drill-through reports.

Cells that contain drill-through reports can be indicated on the grid by a cell style (see Cell Styles).

The data displayed in a drill-through report is dynamic.

Note:

You cannot use alias names for drill-through; you must use member names.

From Oracle Smart View for Office, you can drill through to the detailed data in a database as follows:

  • Supported Oracle Enterprise Performance Management Cloud data sources: You can drill through from your application to detailed data in Data Management or Oracle Hyperion Financial Data Quality Management data sources.

  • Oracle Analytics Cloud - Essbase: You can drill through to relational databases or to URLs.

To access a drill-through report:

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

    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 Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud: 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 will see the message,“"Unauthorized access" or "403, Forbidden". Return to the sheet in Smart View and click the drill-through cell again to launch the drill-through report.