PEL MemberSet functions
The following links provide detailed reference information about the PerformancePoint Expression Language (PEL) functions that return MemberSet values.
Note
PEL cannot be used to reference user-created member views in non-time dimensions. To write a business rule that references a member view in a non-time dimension, use a native Multidimensional Expressions (MDX) implementation.
Reference
- Ascendants (PEL)
Returns the full MemberSet of ancestors for a specified member all the way up to the root of the hierarchy.
- BottomCount (PEL)
Sorts a MemberSet in ascending order, and returns the MemberSet with the lowest values.
- BottomPercent (PEL)
Sorts a MemberSet in ascending order, and returns a MemberSet with the lowest values whose cumulative total is equal to or less than a specified percentage.
- BottomSum (PEL)
Sorts a MemberSet in ascending order, and returns a MemberSet with the lowest values whose total is equal to or less than a specified value.
- Children (PEL)
Returns the children of a specified member. If applied to a leaf member, the returned MemberSet is empty.
- Descendants (PEL)
Returns a MemberSet of descendants from a specified member by using a specified level, or numeric distance from the specified member’s level, as a reference point.
- Except (PEL)
Finds the difference between two MemberSets.
- Filter (PEL)
Returns the MemberSet that results from filtering a specified MemberSet based on a search condition.
- Generate (PEL)
Applies a MemberSet to each member of another MemberSet, and then joins the resulting MemberSets by union.
- Intersect (PEL)
Returns the intersection of two input MemberSets.
- LastPeriods (PEL)
Returns a MemberSet of members up to and including a specified member.
- LeafMembers (PEL)
Retrieves the leaf members at or below the specified member.
- Members (PEL)
Retrieves a set of members in a specified dimension, level, or hierarchy.
- PeriodsToDate (PEL)
Returns a MemberSet 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.
- Range (PEL)
Specifies an inclusive range from begin to end relative to the specified member.
- Siblings (PEL)
Returns the MemberSet of siblings of the specified member. The resulting MemberSet includes the specified member.
- TopCount (PEL)
Sorts a MemberSet in descending order and returns the specified number of elements with the highest values.
- TopPercent (PEL)
Sorts a MemberSet in descending order, and returns a MemberSet with the highest values whose cumulative total is equal to or less than a specified percentage.
- TopSum (PEL)
Sorts a MemberSet and returns the topmost elements whose cumulative total is at least a specified value.
- Union (PEL)
Returns the union of two MemberSets.