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

Counting Tuples in Sets

As demonstrated in the previous chapter, sets can be constructed using complex criteria. Although such sets are frequently employed along query axes, occasionally such sets are constructed for no other purpose than to identify the number of tuples meeting the stated criteria. In these situations, the MDX Count function is frequently employed:

Count( {Set} [, Flag])

The MDX Count function is similar to the other MDX aggregation functions in that it operates over a set. If no flag is provided or if the INCLUDEEMPTY flag is specified, the function simply returns a count of the tuples in that set. With the EXCLUDEEMPTY flag, the set is evaluated employing the current measure and those tuples associated with a non-empty cell are ...

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