Members (PEL)
This function retrieves a set of members in a specified level or hierarchy.
// Hierarchy expression syntax
Hierarchy_Expression.Members
// Level expression syntax
Level_Expression.Members
Parameters
- Hierarchy_Expression
A valid PerformancePoint Expression Language (PEL) expression that returns a hierarchy
- Level_Expression
A valid PEL expression that returns a level
Return value
If a hierarchy expression is specified, the Members function returns the set of all members within Hierarchy_Expression.
If a level expression is specified, the Members function returns the set of all members within Level_Expression.
Remarks
The PEL compiler can generate SQL code for this function when the function is part of an absolute reference. The compiler cannot generate SQL code when the function is part of a relative reference.
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
SQL generation for PEL functions
Other Resources
PEL reference
Multidimensional Expressions (MDX) Reference on MSDN