Chapter 8. Navigating Hierarchies

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

Get Microsoft® SQL Server® 2008 MDX Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.