OpeningPeriod (PEL)

This function retrieves the first sibling among the descendants of a specified member at a specified level.

Member_Expression.OpeningPeriod( Level_Expression )


  • 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.


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


ClosingPeriod (PEL)
SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN