Returns a set 
AddCalculatedMembers 
Adds calculated members to a set.

AllMembers 
Returns a set containing all members of a specified dimension or level,
including calculated members.

Ancestors 
Returns all the ancestors of a member at a specified distance.

Ascendants 
Returns the set of the ascendants of the member, including the member itself.

Axis 
Returns the set associated with the main axis.

BottomCount 
Returns a specified number of items from the bottom of a set, optionally
ordering the set first.

BottomPercent 
Sorts a set and returns the bottom n elements whose cumulative total is at
least a specified percentage.

BottomSum 
Sorts a set and returns the bottom n elements whose cumulative total is at
least a specified value.

Children 
Returns the children of a member.

Correlation 
Returns the correlation of two series evaluated over a set.

Crossjoin 
Returns the cross product of two sets.

Descendants 
Returns the set of descendants of a member at a specified level or at a
specified distance from a member, optionally including or excluding descendants
in other levels.

Distinct 
Eliminates duplicate tuples from a set.

DistinctCount 
Returns the count of tuples in a set, excluding duplicate tuples.

DrilldownLevel 
Drills down the members of a set, at a specified level, to one level below.
Alternatively, drills down on a specified dimension in the set. 
DrilldownLevelBottom 
Drills down the bottom n members of a set, at a specified level, to one level
below.

DrilldownLevelTop 
Drills down the top n members of a set, at a specified level, to one level
below.

DrilldownMember 
Drills down the members in a set that are present in a second specified set.

DrilldownMemberBottom 
Similar to DrilldownMember, except that it includes only the bottom n children.

DrilldownMemberTop 
Similar to DrilldownMember, except that it includes only the top n children.

DrillupLevel 
Drills up the members of a set that are below a specified level.

DrillupMember 
Drills up the members in a set that are present in a second specified set.

Except 
Finds the difference between two sets, optionally retaining duplicates.

Extract 
Returns a set of tuples from extracted dimension elements. The opposite of
Crossjoin.

Filter 
Returns the set resulting from filtering a set based on a search condition.

Generate 
Applies a set to each member of another set and joins the resulting sets by
union.

Head 
Returns the first specified number of elements in a set.

Hierarchize 
Orders the members of a set in a hierarchy.

Intersect 
Returns the intersection of two input sets, optionally retaining duplicates.

LastPeriods 
Returns a set of members prior to and including a specified member.

Members 
Returns the set of all members in a dimension, hierarchy, or level.

Mtd 
A shortcut function for the PeriodsToDate function that specifies the level to
be Month.

NameToSet 
Returns a set containing a single member based on a string expression
containing a member name.

NonEmptyCrossjoin 
Returns the cross product of two or more sets, excluding empty members.

Order 
Arranges members of a set, optionally preserving or breaking the hierarchy.

ParallelPeriod 
Returns a member from a prior period in the same relative position as a
specified member.

PeriodsToDate 
Returns a set of periods (members) from a specified level starting with the
first period and ending with a specified member.

Qtd 
A shortcut function for the PeriodsToDate function that specifies the level to
be Quarter.

Siblings 
Returns the siblings of a member, including the member itself.

StripCalculatedMembers 
Removes calculated members from a set.

StrToSet 
Constructs a set from a string expression.

Subset 
Returns a subset of elements from a set.

Tail 
Returns a subset from the end of a set.

ToggleDrillState 
Toggles the drill state of members. This function is a combination of
DrillupMember and DrilldownMember.

TopCount 
Returns a specified number of items from the top of a set, optionally ordering
the set first.

TopPercent 
Sorts a set and returns the top n elements whose cumulative total is at least a
specified percentage.

TopSum 
Sorts a set and returns the top n elements whose cumulative total is at least a
specified value.

Union 
Returns the union of two sets, optionally retaining duplicates.

VisualTotals 
Dynamically totals child members specified in a set using a pattern for the
total label in the result set.

Wtd 
A shortcut function for the PeriodsToDate function that specifies the level to
be Week.

Ytd 
A shortcut function for the PeriodsToDate function that specifies the level to
be Year.

Returns a tupel 
Current 
Returns the current tuple from a set during an iteration.

ItemItem 
Returns a member from a tuple or a tuple from a set.

StrToTuple 
Constructs a tuple from a string.

ValidMeasure 
Returns a valid measure in a virtual cube by forcing inapplicable dimensions to
their top level.

Returns a member 
Ancestor 
Returns the ancestor of a member at a specified level or at a specified
distance from the member.

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.

CurrentMember 
Returns the current member along a dimension during an iteration.

DataMember 
Returns the systemgenerated data member associated with a nonleaf member.

DefaultMember 
Returns the default member of a dimension or hierarchy.

FirstChild 
Returns the first child of a member.

FirstSibling 
Returns the first child of the parent of a member.

Ignore 
Prevents further recursion along the dimension 
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.

LinkMember 
Returns a hierarchized member.

Members 
Returns the member represented by the 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.

Parent 
Returns the parent of a member.

PrevMember 
Returns the previous member in the level that contains a specified member.

StrToMember 
Returns a member based on a string expression.

Returns a value or something else 
Aggregate 
Returns a calculated value using the appropriate aggregate function, based on
the context of the query.

Avg 
Returns the average value of a numeric expression evaluated over a set.

CalculationCurrentPass 
Returns the current calculation pass of a cube for the current query context.

CalculationPassValueCalculationPassValue 
Returns the value of an MDX expression evaluated over the specified calculation
pass of a cube.

Call UDF (args) 
Executes the string expression containing a userdefined function.

CoalesceEmptyCoalesceEmpty 
Coalesces an empty cell value to a string or number.

Count 
Returns the number of dimensions in a cube, the number of levels in a
dimension, the number of cells in a set, or 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.

Generate 
Evaluate a string expression for each member of a set 
Iif 
Returns one of two numeric or string 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.

LookupCubeLookupCube 
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 evaluated over a set.

Median 
Returns the median value of a numeric expression evaluated over a set.

MemberToStr 
Constructs a string from a member.

Min 
Returns the minimum value of a numeric expression evaluated over a set.

Name 
Returns the name of a dimension, hierarchy, level, or member.

Ordinal 
Returns the zerobased ordinal value associated with a level.

Predict 
Evaluates the string expression within the data mining model specified within
the current coordinates.

Properties 
Returns a string containing a member property value.

Rank 
Returns the onebased rank of a tuple in a set.

RollupChildren 
Scans the children of the member parameter and applies the string expression
operator to their evaluated value.

SetToArray 
Converts one or more sets to an array for use in a userdefined function.

SetToStr 
Constructs a string from a set.

Stddev 
Alias for Stdev.

StddevP 
Alias for StdevP.

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.

StrToValueStrToValue 
Returns a value based on a string expression.

Sum 
Returns the sum of a numeric expression evaluated over a set.

TupleToStr 
Constructs a string from a tuple.

UniqueName 
Returns the unique name of a dimension, level, or member.

UserName 
Returns the domain name and user name of the current connection.

ValueValue 
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.

VarianceP 
Alias for VarP.

VarP 
Returns the population variance of a numeric expression evaluated over a set,
using the biased population formula.
