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 Sets with Functions

The exercises and examples presented thus far make use of explicit set declarations. In other words, individual sets are assembled from individual tuples using individual member references. Although building sets this way is perfectly valid and at times necessary or even preferable, many other times, especially when set membership is dynamic, sets are best built employing the MDX set-building functions. The most frequently employed of these functions are Members and Crossjoin.

The Members Function

The Members function is the most basic and frequently used of the set-building functions. It is a very simple function with no parameters or qualifiers other than the name of the hierarchy or hierarchy level from which a set ...

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