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 ...
Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
