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 recipes to continue.
How to do it...
We are creating the most common hierarchy, the time:
Click on the Schema Objects | Hierarchies folder. Then open the Data Explorer folder.
Right-click on the right pane and from the context menu select New | Hierarchy...
