A hierarchy is a concept where related items are represented as being above, below, or at the same level as each other.
Some examples of hierarchies include:
- Organisation charts with different levels of managers and employees;
- Calendars with dates organized in years, months, and days;
- Products arranged into different classes, groups, or brands; and
- Bills of material grouped into sub assemblies, kits, and components.
Each of these hierarchies include “parent” members and “child” members beneath them, and serve as a way of organizing information into different levels. Continue reading “Hierarchies #1: Introduction to hierarchies in Analysis Services and Power BI”