O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required