How to work with Dimension Leaves
Dimension leaves is one of the fundamental concepts in OLAP. Dimension leaves are used in variety of situations – from defining calculations on the leaves to aggregate up, and to different UI icons for leaves vs. non-leaves. But while it may seem that this concept is simple, it is actually more complicated. Most of the confusion comes from the fact, that there are two distinct concepts, both of which are commonly called leaves:
- Hierarchy leaves
- Measure group leaves
In this article we will explain the differences between the two and discuss the Analysis Services and MDX support for both of these concepts.
Tags: mdx