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

Filtering Sets

Effective data analysis requires you to narrow your focus to the most critical and revealing data. This data is often identified through complex criteria that go beyond positioning at the top or bottom of a set or the exploitation of relationships as explored in Chapter 4.

To support the evaluation of complex criteria for set membership, MDX provides the Filter function:

Filter( {Set}, Expression)

The Filter function works by evaluating each tuple in the set provided in the function’s first argument by a logical expression provided in the function’s second argument. Those tuples for which the expression evaluates to True are included in the set returned by the function.

The logical expression consists of one or more logical comparisons. ...

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