MicroStrategy ONE

Drill Maps and Drill Paths

Drill maps determine the options available to an end user when drilling on a report. When a user right-clicks an object on a report and chooses the drill option, he is displaying drill maps.

When the drill hierarchies are created, a default drill map is created. If no drill hierarchies are created, the system hierarchy is used to create the default drill map. The drill map determines what options are available to users when they drill on a report object. These different options are referred to as drill paths, which include the destination of the drill. The destination can be an attribute, a consolidation, a hierarchy, or a template.

All projects must have a default drill map; you cannot delete it unless you first specify a new default drill map. The default project drill map is specified in the Project Configuration Editor.

If you try to delete the only default drill map for a project, a message indicates that other objects depend on it. When you search for dependent objects, none are found. The dependent object is the project itself.

In summary, a drill map determines what drill paths are available while drilling from a report object. By default, the drill paths available to a report object reflect exactly the drill hierarchies of the project.