Common MDX functions

Common MDX functions

The following table describes some of the more common MDX functions:

MDX Function	Description
Ancestor	Returns the ancestor of a member at a specified level.
ClosingPeriod	Returns the last sibling among the descendants of a member at a level.
Cousin	Returns the member with the same relative position under a member as the member specified.
Current Member	Returns the current member along a dimension during an iteration.
Default Member	Returns the default member of a dimension.
FirstChild	Returns the first child of a member.
FirstSibling	Returns the first child of the parent of a member.
IsEmpty	Determines if an expression evaluates to the empty cell value.
Item	Returns a member from a tuple.
Lag	Returns a member prior to the specified member along the member's dimension.
LastChild	Returns the last child of a member.
LastSibling	Returns the last child of the parent of a member.
Lead	Returns a member further along the specified member's dimension.
Members	Returns the member whose name is specified by a string expression.
NextMember	Returns the next member in the level that contains a specified member.
OpeningPeriod	Returns the first sibling among the descendants of a member at a level.
ParallelPeriod	Returns a member from a prior period in the same relative position as a specified member.
Parent	Returns the parent of a member.
PrevMember	Returns the previous member in the level that contains a specified member.
Aggregate	Returns a calculated value using the appropriate aggregate function, based on the context of the function.
Avg	Returns the average value of a numeric expression evaluated over a set.
CoalesceEmpty	Coalesces an empty cell value to a number.
Correlation	Returns the correlation of two series evaluated over a set.
Count	Returns the number of tuples in a set, empty cells included unless the optional EXCLUDEEMPTY flag is used.
IIf	Returns one of two values determined by a logical test.
LinRegIntercept	Calculates the linear regression of a set and returns the value of b in the regression line y = ax + b.
LinRegPoint	Calculates the linear regression of a set and returns the value of y in the regression line y = ax + b.
LinRegR2	Calculates the linear regression of a set and returns R2 (the coefficient of determination).
LinRegSlope	Calculates the linear regression of a set and returns the value of a in the regression line y = ax + b.
LinRegVariance	Calculates the linear regression of a set and returns the variance associated with the regression line y = ax + b.
Max	Returns the maximum value of a numeric expression evaluated over a set.
Median	Returns the median value of a numeric expression evaluated over a set.
Min	Returns the minimum value of a numeric expression evaluated over a set.
Sum	Returns the sum of a numeric expression evaluated over a set.

For additional NW BI MDX keywords, run function module BAPI_MDPROVIDER_GET_FUNCTIONS via transaction SE37.