Testing Reports for Relational Sources

Use this procedure for testing drill-through reports based on relational sources. This procedure outlines a general method for testing. For other testing scenarios, see Example Testing Scenarios—When Caption and Key Bindings Differ and Example Testing Scenario—Recursive Hierarchies.

  To test the drill-through report:

  1. In the Report Contents tab, click Test.

  2. Select a Cube Schema to use for testing.

  3. Provide a Column Value for each intersection.

    Under Intersection, the columns you selected as intersections on the Context tab are displayed. You may also click in the intersection cell, select the down arrow at the right of the cell, and choose a column from a drop-down list of all available columns under the same intersection. Under Column Value, enter a valid value for each column you select.

    For example, using the TBC sample database, if Family is displayed as an intersection, enter 300 in the Column Value column to view results for the 300 product family. Further, use the drop-down list in the intersection cell for Family to select another column from a list of available drill-through columns; for example, SKU, and enter 300-30 in the Column Value column.

    When testing a recursive hierarchy, the Intersection and Column Value fields of the Drill-through Report Testing dialog box are used differently than when testing a standard hierarchy:

    • In the Intersection field, the recursive hierarchy name is displayed. For example, if the recursive hierarchy is named “recur_hier,” then recur_hier is displayed.

    • In the Column Value field, a valid parent or child column name is entered, not a data value.

  4. Optional: Enter an integer to specify the Maximum rows to display.

    The default is to display 20 rows.

  5. Click Show Result.

    View the “Resulting report” section to see how results will be displayed in the drill-through report.

  6. Click Close to return to the Report Contents tab of the drill-through report editor.

  7. Click Save and then Close to close the Drill-through Report Testing dialog box.

    To continue defining the drill-through report, select the Associations tab and perform the tasks in Associating Drill-through Reports with Essbase Models.

Example testing scenarios are provided in: