1. Using Oracle Essbase
  2. Access External Data with Drill Through Reports
  3. Test Drill Through Reports

Test Drill Through Reports

To test drill through reports, prepare Smart View, perform drill through operations, check the output, and check the platform log if you do not get the results you expect.

Prepare Smart View

  1. Install the latest Smart View version.
  2. Connect to the cube.
  3. Enable cell styles to show drillable regions in the Smart View sheet.
    1. On the Smart View ribbon, click Options.
    2. Under Formatting, ensure that Use Cell Styles is selected.
    3. Expand Essbase, then Member Cells. Check Member Drill-through, then right click it and choose a style (for example, a blue background).
    4. Expand Data Cells. Check Drill-through, then right click it and choose the same style.
      Image of the Smart View Options dialog box, with Cell Styles selected and a blue background defined for Member drill-through (under Essbase) and Drill-through (under Data cells).

Drill Through to an External Source of Data

Drill through from one or more drillable cells to your external source of data.

  1. Connect to your cube in Smart View.
  2. Drill down into the drillable regions you specified in your drill through report definition.

    Drillable cells are highlighted using the cell style you selected when preparing Smart View.

  3. Select one or more cells and click Drill-through on the Essbase ribbon.

    The image shows drill through from a single cell. You can also drill through from multiple cells. The cells can include a range or multiple ranges. They can be contiguous or non-contiguous, and can include different generations in the hierarchy.


    Image of a Smart View grid with a single cell (at an intersection of Cola) selected for drill through, and the drill-through option on the Essbase ribbon highlighted.

  4. View the results.

    When you drill through, a new sheet is opened showing the results of the drill through operation. Results depend upon the context of the cell or cells from which you drill through. See How Drill Through Works.


    Image of spreadsheet with result of a single-cell drill through operation.

Check the Drill Through Report Outputs and the Platform Log

Check drill through report outputs by performing drill through operations and analyzing the results.

If you are not seeing the results you expect, check the Debug Drill Through using Essbase Server Platform Log to debug your reports.

Note:

If a drill through report fails and you find an error, 'ERROR: relation <member name> does not exist' in the platform log, see Expand Limit for SQL IN Clauses in Drill Through Reports.