OpeningPeriod (PEL)
This function retrieves the first sibling among the descendants of a specified member at a specified level.
Member_Expression.OpeningPeriod( 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
The OpeningPeriod function returns the first descendant of Member_Expression at the Level_Expression.
Remarks
Typically, this function is used in the Time dimension but can be used with any dimension.
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
ClosingPeriod (PEL)
SQL generation for PEL functions
Other Resources
PEL reference
Multidimensional Expressions (MDX) Reference on MSDN