Business Intelligence with MicroStrategy Cookbook

Building Data Explorer Hierarchies

In every MicroStrategy project, there is a default system hierarchy that is built automatically based on the information we set into the Parent/Children tabs of the Attribute Editor. The default system hierarchy cannot be modified and contains all the attributes in a project.

The hierarchies can be used to drill down and up in reports, for example, from Year to Month to Date; or from Product Category to Product.

In order to present the attributes in clear and understandable groups to the users, additionally, we can create other hierarchies that we will later use in reports and in dynamic selectors; think of it as a different way to show dimensions to the end user.

Getting ready

You need to have completed the previous ...