| Function | Description |
| Aggregate | Returns a scalar value calculated by aggregating either measures or an optionally specified numeric expression over the tuples of a specified set. |
| Avg | Returns the average value of measures or the average value of an optional numeric expression, evaluated over a specified set. |
| CalculationCurrentPass | Returns the current calculation pass of a cube for the specified query context. |
| CalculationPassValue | Returns the value of a MDX expression evaluated over the specified calculation pass of a cube. |
| CoalesceEmpty | Coalesces an empty cell value to a number or string and returns the coalesced value. |
| Correlation | Returns the correlation coefficient of two series evaluated over a set. |
| Count (Dimension) | Returns the number of dimensions in a cube. |
| Count (Hierarchy Levels) | Returns the number of levels in a dimension or hierarchy. |
| Count (Set) | Returns the number of cells in a set. |
| Count (Tuple) | Returns the number of dimensions in a tuple. |
| Covariance | Returns the population covariance of two series evaluated over a set, using the biased population formula. |
| CovarianceN | Returns the sample covariance of two series evaluated over a set, using the unbiased population formula. |
| DistinctCount | Returns the number of distinct, nonempty tuples in a set. |
| IIf | Returns one of two values determined by a logical test. |
| LinRegIntercept | Calculates the linear regression of a set and returns the value of the intercept 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 the coefficient of determination, R2. |
| LinRegSlope | Calculates the linear regression of a set, and returns the value of the slope 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. |
| LookUpCube | Returns the value of an MDX expression evaluated over another specified cube in the same database. |
| Max | Returns the maximum value of a numeric expression that is evaluated over a set. |
| Median | Returns the median value of a numeric expression that is evaluated over a set. |
| Min | Returns the minimum value of a numeric expression that is evaluated over a set. |
| Ordinal | Returns the zero-based ordinal value associated with a level. |
| Predict | Returns a value of a numeric expression evaluated over a data mining model. |
| Rank | Returns the one-based rank of a specified tuple in a specified set. |
| RollupChildren | Returns a value generated by rolling up the values of the children of a specified member using the specified unary operator. |
| Stddev | Alias for Stdev (MDX). |
| StddevP | Alias for StdevP (MDX). |
| Stdev | Returns the sample standard deviation of a numeric expression evaluated over a set, using the unbiased population formula. |
| StdevP | Returns the population standard deviation of a numeric expression evaluated over a set, using the biased population formula. |
| StrToValue | Returns the value specified by an MDX-formatted string. |
| Sum | Returns the sum of a numeric expression evaluated over a set. |
| Value | Returns the value of a measure. |
| Var | Returns the sample variance of a numeric expression evaluated over a set, using the unbiased population formula. |
| Variance | Alias for Var (MDX). |
| VarianceP | Alias for VarP (MDX). |
| VarP | Returns the population variance of a numeric expression evaluated over a set, using the biased population formula. |