Drilling on a document

Drilling is one of the most powerful data analysis functionalities in any reporting environment. Drilling lets you explore data beyond the data immediately visible in a grid. You can drill through a grid to analyze data that is closely related to the original data, or you can expose an entirely different object on a grid to see what the data looks like within a different context.

You can drill on a Grid/Graph:

in Interactive Mode and Editable Mode. You can drill down, up, or across attributes, custom groups, and consolidations displayed in a Grid/Graph in Interactive Mode and Editable Mode.
in Express Mode, if sorting and pivoting are enabled. For steps to enable sorting and pivoting in Express Mode, see Sorting and pivoting in documents in Flash Mode and Express Mode. In Express Mode, you can drill only on the default drill path of an attribute. This is defined when a drill map is created. For instructions to create a drill map, see the MicroStrategy Advanced Reporting Guide.
in Flash Mode, if drilling is enabled in Flash Mode. For steps to enable drilling using a context menu in Flash Mode, see Enabling filtering, drilling, and moving objects in Flash Mode.

For detailed examples of drilling in Grid/Graphs, see the Displaying Reports in Documents: Grid/Graphs chapter of the MicroStrategy Reports Services Document Analysis Guide.

To drill on a Grid/Graph

Prerequisites

If you are drilling on a Grid/Graph in Express Mode, sorting and pivoting in Express Mode must be enabled. For steps to enable sorting and pivoting in Express Mode, see Sorting and pivoting in documents in Flash Mode and Express Mode.
If you are drilling on a Grid/Graph in Flash Mode, drilling using the interactive context menu for grids in Flash Mode must be enabled. For steps to enable the context menu, see Enabling filtering, drilling, and moving objects in Flash Mode.

Open the document in Interactive, Editable, Express, or Flash Mode. Objects that can be drilled on are displayed with an underline.
Do one of the following:

To drill on the Grid/Graph in Interactive Mode or Editable Mode, right-click an underlined object on the Grid/Graph, point to Drill, then select the destination object. To select multiple objects, press and hold CTRL while clicking the objects.
To drill on the Grid/Graph in Express Mode, click an underlined object on the Grid/Graph. To select multiple objects, press and hold CTRL while clicking the objects.
To drill on the Grid/Graph in Flash Mode, perform the following steps:

Hover the cursor over the row or column header of the object you want to use to drill. The context menu icon is displayed in the top right.
Click the context menu icon . The context menu is displayed. Any objects to which you can drill are listed at the top of the context menu.
From the menu, select the object you want to drill to.