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

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.

Depending on your data source, you can open drill-through reports in the following ways:

If the Oracle Enterprise Performance Management Cloud source uses Oracle Enterprise Data Management Cloud to load data for drill-through reports, you can drill to source data in a new sheet or a web browser.

For Oracle Essbase data source, you can drill through using grids or URLs. If the drill-through report is set as a grid, then it is displayed in a new sheet. If it is set as a URL, then the report is launched in a web browser.

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.
  • In order to use the drill-through feature in Chrome, you must enable pop-ups. See the note below.

To access a drill-through report:

  1. Select a data cell associated with a drill-through report.
  2. From the provider ribbon or provider ad hoc ribbon, select Drill-through Drill Through button.

  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:

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.