In the Query section, you execute the drill through to relational. If drill through indicators have been enabled, the blue cell indicators are only displayed for the top/left cell or member label because all data cells and all member labels in a dimension can be drilled on.
To execute a drill through:
Select a single cell or member label and on the shortcut menu, select Drill Through.
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 on the shortcut menu.
The Drill to Results dialog is displayed.
This dialog box is only displayed if the option “Existing Results” was selected in the Drill To drop down box. You are prompted to enter a user name and password to the relational query.
By default there is New Results, and the dialog box is not shown.