The following categories of functions return a set or a set value expression.
Functions in this category derive their results without getting any further information from the cube.
| Function | Result |
|---|---|
| CrossJoin | Returns a cross-section of two sets from different dimensions. |
| Distinct | Deletes duplicate tuples from a set. |
| Except | Returns a subset containing the differences between two sets. |
| Generate | For each tuple in set1, return set2. |
| Head | Returns the first n members or tuples present in a set. |
| Intersect | Returns the intersection of two input sets. |
| Subset | Returns a subset from a set, in which the subset is a numerically specified range of tuples. |
| Tail | Returns the last n members or tuples present in a set. |
| TupleRange | Returns the range of tuples between (and inclusive of) two tuples at the same level. |
| Union | Returns the union of two input sets. |
Functions in this category derive their results using metadata information from the cube.
| Function | Result |
|---|---|
| Ancestors | Returns a set of ancestors up to a specified layer or distance. |
| Attribute | Returns all base members that are associated with the specified attribute member. |
| Children | Returns all child members of the input member. |
| Descendants | Returns the set of descendants of a member at specified layers. |
| DrilldownByLayer | Drills down members of a set that are at a specified layer. |
| DrilldownMember | Drills down on any members or tuples of <set1> that are also found in <set2>. |
| DrillupByLayer | Drills up the members of a set that are below a specified layer. |
| DrillupMember | Tests two sets for common ancestors, and drills up members in the first set to the layer of the ancestors which are present in the second set. |
| Extract | Returns a subset containing only the tuples of a specified dimensionality. |
| Hierarchize | Sorts members according to the default member ordering as represented in the database outline. |
| LastPeriods | Returns a set of members ending either at the specified member or at the current member in the time dimension. |
| MemberRange | Returns the range of members positioned between two input members (inclusive) at the same generation or level. |
| Members | Returns a set of all members of a given dimension, hierarchy, or layer. |
| PeriodsToDate | Returns a set of dynamic-time-series members from the beginning of a given layer up to a given member in that layer (or up to the default member); or, returns members up to the current member of the Time dimension. |
| RelMemberRange | Returns a set based on the relative position of the specified member. |
| Siblings | Returns the siblings of the input member. |
| Uda | Returns all members that share a specified user-defined attribute. |
| WithAttr | Returns all base members that are associated with an attribute member of the specified type. |
| AttributeEx | Given the varying attribute member and the perspective setting, returns the associated base member list. |
| WithAttrEx | Given the varying attribute dimension, condition, predicate, and perspective setting, returns the base member list satisfying the predicate. |
| xTD | Functions returning period-to-date values. |
Functions in this category derive their results using data values from the cube.
| Function | Result |
|---|---|
| BottomCount | Returns a set of n elements ordered from smallest to largest, optionally based on an evaluation. |
| BottomPercent | Returns the smallest possible subset, with elements listed from smallest to largest, of a set for which the total results of a numeric evaluation are at least a given percentage. |
| BottomSum | Returns the smallest possible subset, with elements listed from smallest to largest, of a set for which the total results of a numeric evaluation are at least a given sum. |
| Case | Performs conditional expressions. |
| Filter | Returns those parts of a set which meet the criteria of a search condition. |
| IIF | Performs a conditional test, and returns an appropriate numeric expression or set depending on whether the test evaluates to true or false. |
| Leaves | Returns the set of level 0 (leaf) members that contribute to the value of the specified member. |
| Order | Sorts members of a set in order based on an expression. |
| TopCount | Returns a set of n elements ordered from largest to smallest, optionally based on an evaluation. |
| TopPercent | Returns the smallest possible subset, with elements listed from largest to smallest, of a set for which the total results of a numeric evaluation are at least a given percentage. |
| TopSum | Returns the smallest possible subset, with elements listed from largest to smallest, of a set for which the total results of a numeric evaluation are at least a given sum. |