After completing this chapter, you will be able to:
Explain the use of the various navigational MDX functions
Use the navigational functions to locate members within a hierarchy
Evaluate a given member’s position within a hierarchy
A defining feature of Analysis Services is the organization of members within hierarchies. For a given hierarchy—whether an attribute- or user-hierarchy—a member resides at a precise location within a specific level. Its position is determined by its relationship to members in higher levels and the ordering of the members within its own level.
The deterministic nature of a member’s position within a hierarchy allows members to be located relative to one another. This is referred to as