MicroStrategy ONE

Drilling

Drilling allows navigation to different levels of information within a report. You can drill from one level of information to lower or higher levels of detail. For example, if your data is organized by regions, markets, and stores, and you run a report that shows region sales, you can drill down from the region level to see the sales for the markets that make up that region. Conversely, you can drill up from stores to view the markets to which those stores belong.

The generation of the new report instance based on such a  selection is called drilling transformation.

Since there are multiple ways to transform a report instance into another report instance, you have the flexibility of associating different drill actions with a report.  This presents a selection of multiple drill paths with which the report can be transformed. Since a complete specification of the drill paths on a report can be complex, default drill paths are provided based on the definitions of objects used in the report.

Refer to the interfaces section for all the interfaces that are available for drilling. These interfaces help you understand the code samples provided in the examples section.