Function	Description
AddCalculatedMembers	Returns a set generated by adding calculated members to a specified set.
AllMembers	Returns a set that contains all members, including calculated members, of the specified dimension, hierarchy, or level.
Ancestors	Returns a set of all ancestors of a member at a specified level or distance.
Ascendants	Returns the set of the ascendants of a specified member, including the member itself.
Axis	Returns a set defined in an axis.
BottomCount	Sorts a set in ascending order, and returns the specified number of tuples with the lowest values.
BottomPercent	Sorts a set in ascending order, and returns a set of tuples with the lowest values whose cumulative total is equal to or less than a specified percentage.
BottomSum	Sorts a set in ascending order, and returns a set of tuples with the lowest values whose total is equal to or less than a specified value.
Children	Returns the children of a specified member.
CrossJoin	Returns the cross product of one or more sets.
CurrentOrdinal	Returns the current iteration number within a set during iteration.
Descendants	Returns the set of descendants of a member at a specified level or distance, optionally including or excluding descendants in other levels.
Distinct	Returns a set, removing duplicate tuples from a specified set.
DrilldownLevel	Drills down the members of a set to one level below the lowest level represented in the set, or to one level below an optionally specified level of a member represented in the set.
DrilldownLevelBottom	Drills down the bottommost members of a set, at a specified level, to one level below.
DrilldownLevelTop	Drills down the topmost members of a set, at a specified level, to one level below.
DrilldownMember	Drills down the members in a specified set that are present in a second specified set. Alternatively, the function drills down on a set of tuples.
DrilldownMemberBottom	Drills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of members. Alternatively, this function also drills down on a set of tuples.
DrilldownMemberTop	Drills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of members. Alternatively, this function drills down on a set of tuples.
DrillupLevel	Drills up the members of a set that are below a specified level.
DrillupMember	Drills up the members in a specified set that are present in a second specified set.
Except	Finds the difference between two sets, optionally retaining duplicates.
Exists	Returns the set of members of one set that exist with one or more tuples of one or more other sets.
Extract	Returns a set of tuples from extracted dimension elements.
Filter	Returns the set that results from filtering a specified set based on a search condition.
Generate	Applies a set to each member of another set, and then joins the resulting sets by union. Alternatively, this function returns a concatenated string created by evaluating a string expression over a set.
Head	Returns the first specified number of elements in a set, while retaining duplicates.
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 up to and including a specified member.
LateralMembers
Members	Returns the set of members in a dimension, level, or hierarchy.
Mtd	Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Year level in the Time dimension.
NameToSet	Returns a set that contains the member specified by an MDX-formatted string.
NonEmptyCrossjoin	Returns the cross product of one or more sets as a set, excluding empty tuples and tuples without associated fact table data.
Order	Arranges members of a specified set, optionally preserving or breaking the hierarchy.
PeriodsToDate	Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by a specified level in the Time dimension.
Qtd	Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Quarter level in the Time dimension.
Siblings	Returns the siblings of a specified member, including the member itself.
StripCalculatedMembers	Returns a set generated by removing calculated members from a specified set.
StrToSet	Returns the set specified by an MDX-formatted string.
Subset	Returns a subset of tuples from a specified set.
Tail	Returns a subset from the end of a set.
ToggleDrillState	Toggles the drill state of members.
TopCount	Sorts a set in descending order and returns the specified number of elements with the highest values.
TopPercent	Sorts a set in descending order, and returns a set of tuples with the highest values whose cumulative total is equal to or less than a specified percentage.
TopSum	Sorts a set and returns the topmost elements whose cumulative total is at least a specified value.
Union	Returns the union of two sets, optionally retaining duplicates.
Unorder	Removes any enforced ordering from a specified set.
VisualTotals	Returns a set generated by dynamically totaling child members in a specified set, optionally using a pattern for the name of the parent member in the resulting cellset.
Wtd	Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Week level in the Time dimension.
Ytd	Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Year level in the Time dimension.