O'Reilly logo

Business Intelligence with MicroStrategy Cookbook by Davide Moraschi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Going deeper into data with drill down

In BI, when we analyze numbers at a deeper level or at a higher level, we speak about drilling. Going deeper is referred to as drill down and vice versa is called drill up. Sometimes, you may also find the term drill across, which refers to a change in the point of view by moving the perspective to a different dimension (or hierarchy).

MicroStrategy uses hierarchies to drill into data. In Chapter 3, Schema Objects – Attributes, we learned how to create a hierarchy from several related attributes: these are called user hierarchies . In addition to those, there is a default system hierarchy that is created automatically with all the attributes in a project.

So, for example, using the time hierarchy we created ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required