Drilling lets you view report data at levels other than that displayed in the report. For an introduction to drilling, levels, and hierarchies, see the MicroStrategy Basic Reporting Guide.
In addition to the drilling method described below, on some reports
you can drill by simply clicking a hyperlink. If a hyperlink appears on
a grid report, this is an object that has a default drilling option. Place
your cursor over the hyperlink to see where the hyperlink (the drill path)
takes you to. Click the hyperlink to drill. A new report opens showing
the drilled-to data. To return to the original report results, click Back above the report.
Click the name of a report to execute it. The report must be in Grid view.
If DHTML is disabled, drill by Using the Drill panel.
Right-click an object, point to Drill, and select a drill path:
Click More options to open the Advanced Drill pane. If the report's designer applied additional drilling paths using a drill template, those paths will be available in this pane.
You can select and drill on multiple objects at one time. For example, you can drill down on both the Year and Region attributes at the same time, so that the drilled-to report shows Quarter and City. To select multiple objects, press CTRL while selecting the objects.
The drilled-to report is executed.
To return to the original report results, click Back
above the report.
Note: Pressing the Back
button on your browser does not return you to the original report results.
You can drill on more than one attribute or metric at a time. For steps, see Using the Drill panel.
Related topics