Working with Drill-Through Reports

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

Using drill-through reports, you can drill through to the detailed data in a database from Smart View. Drill-through helps you to understand the source of a data value and get a granular level of detail for a value. For example, when you drill down on the Period dimension member Q4, you may see values for Jan, Feb and Mar.

Drill-through reports can be launched in a web browser from Smart View. Support for launching drill-through reports in a new sheet will be made available in a future release.

Guidelines for Working with Drill-Through Reports

Consider these guidelines when working with drill-through reports:

  • Cells that contain drill-through reports can be indicated on the grid by a cell style. For more information on setting cell styles, see Formatting Options.
  • The data displayed in a drill-through report is dynamic.
  • You cannot use alias names for drill-through; you must use member names.

Accessing Drill-Through Reports

To access a drill-through report:

  1. Select a data cell associated with a drill-through report.
  2. In the Extensions menu, select Smart View for Google Workspace, and then select Form or Ad Hoc.
  3. Select Data and then select Drill-Through.

  4. 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.

Enabling Pop-ups in Chrome for Using Drill-Through

To enable pop-ups in Chrome for using the drill-through feature, follow these steps:

  1. Click the Chrome menu (the three dots icon Chrome menu button) on the browser toolbar, and select Settings.
  2. Scroll down the page and click the arrow next to Advanced to see more settings.
  3. In the Privacy and Security section, select Content Settings.
  4. Select Pop-ups and Redirects.
  5. In Allow, click Add.

  6. In the Add Site dialog box, enter the URL for your environment, up to the port number; for example:

    https://<serviceURL>.oraclecloud.com

  7. Click Add.

    The URL should appear in the list under Allow.