PeriodsToDate (PEL)
This function returns a set of members at the same level as a given member.
Member_Expression.PeriodsToDate( Level_Expression )
Parameters
- Member_Expression
A valid PerformancePoint Expression Language (PEL) expression that returns a member
- Level_Expression
A valid PEL expression that returns a level
Return value
This function returns a set of members at the same level as Level_Expression for Member_Expression. The function starts with the closest ancestor of Member_Expression and finds the first descendant of the ancestor that is at Level_Expression. The function ends the set collected with Member_Expression.
Remarks
PeriodsToDate
is functionally equivalent to the following PEL expression:
Intersect(
Member_Expression.Ancestor(Level_Expression).Descendants(Member_Expression.@Level), :Member_Expression)
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