Query Studio supports various drill operations so that you can view related data. You can perform drill operations in lists, crosstabs, and charts.
You can
drill up or drill down within the same report
navigate to another target
You can drill up or drill down within the same report. In lists and crosstabs, hyperlinks identify drillable items. In charts, the pointer changes to a hand when you pause the pointer over a drillable item, and a tooltip indicates what you are drilling on. For example, a column chart shows revenue by product line by year. You can drill on a single axis, such as product line or year. You can also drill on both axes, such as Camping Equipment and 2005. In this case, you are drilling on the intersection of Camping Equipment and 2005.
You can also drill up and drill down in a report that is run from Cognos Connection. Reports run from Cognos Connection appear in Cognos Viewer. After you drill up or drill down, you can save the report as a report view for viewing later on. For more information, see the Cognos Connection User Guide.
Drill up and drill down is available only when you are using dimensionally structured data and viewing the report in HTML format. Furthermore, you can drill only on members in a level. For more information about members, levels, and other dimensional objects, see Add Data to a Report. In addition, drill up and drill down must be enabled.
By default, drill up and drill down is enabled.
Tip: To enable drill up and drill down, from the Run Report menu, click Advanced Options. Select the Enable drill up and drill down in the report output check box.
Open the report that you want in Query Studio.
Right-click the report item you want to drill on and click Drill Up or Drill Down.
Tip: You can also click the report item itself.
You can navigate from a Query Studio report to another target. You can navigate to the following targets:
a Query Studio report
a Report Studio report
an Analysis Studio analysis
a Cognos Series 7 cube action
a Microsoft Analysis action
Before you can navigate to another target, a drill-through definition must be created in the package. For more information, contact your administrator. In addition, drill-through from a package must be enabled in Query Studio.
By default, drill-through from a package is enabled.
Tip: To enable drill through, from the Run Report menu, click Advanced Options. Select the Enable drill through from a package in the report output check box.
Open the report you want in Query Studio.
Right-click the report item from which you want to navigate
and click Go To 
.
If there is only one possible target for the column, it appears in Cognos Viewer.
If there is more than one possible target for the column, the Go To page appears, showing the available targets.
Click the target you want to navigate to.
The target appears in Cognos Viewer.
