The Drill Through feature enables users to drill from a data cell or meta data label in a CubeQuery section to an existing relational query section within the same Interactive Reporting document file. In CubeQuery, drill through “blue indicators” may have been enabled to indicate data cells and metadata labels where drill can be executed. The indicators are displayed for the top/left cell or member label because all data cells and all member labels in a dimension can be drilled on. Drill Through has these characteristics:
Essbase dimensions are mapped to the target relational fields, so that the member context in the Essbase query can be passed to the relational query as a filter. Drill through to fact items is not available because facts are defined in the relational query section only.
Drill Through be accomplished at any level of Essbase members in the hierarchy.
You can drill a to new or existing Results section.
To execute a drill through:
Select a single cell or member label and select Actions, then Drill through.
A Drill through can only be performed on one label or cell at a time. If multiple metadata labels and/or cells are selected, the option to drill through is not be available .
The Drill to Results dialog box is displayed.
This dialog box is only displayed if the option “Existing Results” was selected when the Drill Through option was defined. You are prompted to enter a user name and password to the relational query.
By default there are new results, and the dialog box is not shown.