Share via

LeafMembers (PEL)

  • Article

This function returns the leaf members at or below the specified member.

Member_Expression.LeafMembers

Parameters

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

Return values

The function returns a set of leaf members.

Remarks

The following table shows how the LeafMembers function definition depends on the kind of hierarchy.

If the hierarchy is Function definition

Leveled hierarchy

Member_Expression.Descendants(level, SELF), where level is the deepest level in the hierarchy

Nonleveled hierarchy

Member_Expression.Descendants(level, LEAVES), where level is the deepest level in the hierarchy

For more information about these definitions, see the topic Descendants (PEL).

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

Reference

Descendants (PEL)
SQL generation for PEL functions

Other Resources

Multidimensional Expressions (MDX) Reference on MSDN