MicroStrategy ONE

How to Drill 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 Basic Reporting Help.

In addition to the drilling method described below, on some reports you can drill by 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.

For steps to drill on a grid report displayed in a document, see Drill on a Document.

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. To return to the original report results, click BackBack button above the report.

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 How to Use the Drill Panel.

Related Topics

How to Drill on a Graph Report

How to Drill on Objects on the Page-By Axis

How to Use the Drill Panel