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

Building Tuples with User-Hierarchies

The exercises presented thus far have built tuples exclusively using references to members in attribute-hierarchies. You can also use user-hierarchies to assemble tuples. When a user-hierarchy member reference is employed, Analysis Services translates that reference into one or more attribute-hierarchy member references to assemble a resolvable tuple.

Understanding User-Hierarchy Translation

To translate a user-hierarchy member reference into one or more attribute-hierarchy references, Analysis Services first locates the specified member within the user-hierarchy. With this member located, that member and each member in the levels above it forming the member’s lineage in the user-hierarchy is then known. 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