Drilling on a grid report

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 Back button above the report.

To drill on a grid report

  1. Click the name of a report to execute it. The report must be in Grid view.

  2. Right-click an object, point to Drill, and select a drill path:

  3. 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.

  4. 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.

  5. The drilled-to report is executed. To return to the original report results, click Back Back button 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