A dimension is a familiar term: this is information about an object. A dimension could have multiple hierarchies and hierarchies consists of different levels. Hierarchies can have members and levels can have members. Members have children, children have parents....Okay... Let's try visualize this. The diagram below is my interpretation of the different terminology of MDX.
- Hierarchy : Dimensions are defined as structural attributes of a cube made up of levels arranged in hierarchies.
- Member : Members are the occurences of a dimension
- Level : A level is a set of members of a dimension organized such that all members of the set are at an equal distance from the root of the hierarchy
- First child/last child :
- Children : On level down in the hierarchy
- Parent: The member next level up in the hierarchy.
- Grandparent : Two levels up in the hierarchy (2x .parent)
- Great grand parent : Three levels up in the hierarchy (3x .parent)
- Ancestor : Same as the parent.