Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition

Common MDX Functions

To give you a flavor for working with MDX, here is a brief list of commonly used MDX functions types, along with any arguments for each function:

Current:This function returns the current tuple from a set. You should note that this function only works with named sets. You can think of this function as a kind of a CurrentMember function, but one that is specific to named sets.

DistinctCount: This function returns a count of unique, nonempty tuples in a set.

IIF: This function works similarly to IIFs (Immediate If) in other applications (Excel, for example). It takes three arguments: an expression, a value to be returned if the expression evaluates to true, and an alternate value to be returned if the expression evaluates ...