Ascendants (PEL)

Returns the MemberSet of the ascendants of a specified member, including the member itself.



  • Member_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a member.

Return value

Returns all ascendant members related to the member, including itself, in a MemberSet. This is in contrast to the Ancestor (PEL) function, which returns a specific ascendant member, or ancestor, at a specific level.


The PEL compiler can always generate SQL code for this function.

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.

See Also


Ancestor (PEL)
SQL generation for PEL functions

Other Resources

Multidimensional Expressions (MDX) Reference on MSDN