MDX Function Return Values

Functions can be used to generate metadata and/or value information that you need to pass to a SELECT statement. Becoming proficient with the functions reduces the need to enumerate tuples, members, numeric values, or other needed values explicitly in the set specifications of a query. More importantly, using functions allows in-depth analysis of your database.

This section contains a listing of query functions by return value. The possible return values are described in these topics:

• MDX Functions that Return a Member

• MDX Functions that Return a Set

• MDX Functions that Return a Tuple

• MDX Functions that Return a Number

• MDX Functions that Return a Dimension

• MDX Functions that Return a Layer

• MDX Functions that Return a Boolean

• MDX Functions that Return a Date

• MDX Functions that Return a String