Creating Custom Drill Maps and Paths

You can override the default drill map by creating your own custom drill maps and paths. Once you begin customizing a drill map for an object, none of the drill paths of the system hierarchy are available for drilling on that object. For example, before you create a drill map for the attribute Region, the default drill map is the system hierarchy, which allows drilling up to Country and down to Call Center. You create a drill map and add a drill path down to Employee. A user cannot drill to Country or Call Center from Region unless you add these attributes to the new drill map as well.

To create a custom drill path, use the Drill Map Editor to select a destination and drill path type, and define the options, as described in the following sections:

You can:

Create a new drill map as a stand-alone object, which allows you to associate multiple objects with the same drill map. To do this, access the Drill Map Editor directly. From the MicroStrategy Developer, choose New, and then select Drill Map.
Create or edit a drill map for a particular object, access the Drill Map Editor from that object. You can access it from an attribute, custom group, consolidation, template, or report. For steps, see the MicroStrategy Developer help.