Functions (MDX Syntax)

 

Updated: March 2, 2016

Multidimensional Expressions (MDX) has several categories of intrinsic functions to perform certain operations. The following table lists the function categories that are available in MDX.

System_CAPS_ICON_note.jpg Note


For more information about individual functions, see MDX Function Reference (MDX).

Function CategoryDescription
Array functionsProvide arrays for use in stored procedures.

For more information, see Using Stored Procedures (MDX).
Dimension functionsReturn a reference to a dimension from a hierarchy, level, or member.

For more information, see Using Dimension, Hierarchy, and Level Functions.
Hierarchy functionsReturn a reference to a hierarchy from a level or member.

For more information, see Using Dimension, Hierarchy, and Level Functions.
Level functionsReturn a reference to a level from a member, dimension, hierarchy, or from a string expression.

For more information, see Using Dimension, Hierarchy, and Level Functions.
Logical functionsPerform logical operations and comparisons on objects and expressions.

For more information, see Using Logical Functions.
Member functionsReturn a reference to a member from other objects or from a string expression.

For more information, see Using Member Functions.
Numeric functionsPerform mathematical and statistical functions on objects and expressions.

For more information, see Using Mathematical Functions.
Set functionsReturn a reference to a set from other objects or from a string expression.

For more information, see Using Set Functions.
String functionsReturn string values from other objects or from the server.

For more information, see Using String Functions.
Tuple functionsReturn a reference to a tuple from a set or from a string expression.

For more information, see Using Tuple Functions.

Functions can be used or included in any MDX expression. Functions can also be nested (one function used inside another function).

MDX Syntax Elements (MDX)

Community Additions

ADD
Show: