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

Working with Partial Tuples

The cube used in this chapter has a very simple structure. With only five attribute-hierarchies (including Measures), points within this cube are identifiable using a five-part tuple. Imagine a more typical cube with tens or even hundreds of attributes. Having to specify a member reference for each attribute-hierarchy within the cube to complete a tuple would simply be overwhelming.

Thankfully, Analysis Services allows you to submit partial tuples. Within a partial tuple one or more member references are omitted. Because a complete tuple is required to locate a point in the cube space, Analysis Services takes responsibility for filling in the missing references. This is done by applying the following rules for each missing ...

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