MicroStrategy ONE

Tracking your drill path and naming the drilled-to report

When you drill from a report, the name of the resulting, drilled-to report automatically becomes the original report's name plus the name of the object that you drilled to.

For example, in the Inventory and Unit Sales report in the Tutorial project, you can drill from the Item attribute up to the Category attribute. The resulting, drilled-to report's name is "Inventory and Unit Sales -> Category". You then drill from this resulting report by drilling down from Category to Subcategory. The drilled-to report's name is "Inventory and Unit Sales -> Category -> Subcategory". If you then drill across from Subcategory to Region, the resulting report's name is "Inventory and Unit Sales -> Category -> Subcategory -> Region".

You can use this report name to track your drilling path, which is especially useful if you continue to drill from each resulting, drilled-to report.

If you drill repeatedly along a single path, at some point the report's name can become too long or cumbersome to be useful. Consider saving a specific drilled-to report with a new name that is useful for you. Then, when you continue drilling from that report, your drill path as reflected by each resulting report's name is shorter and more useful again.