ParallelPeriod (PEL)

This function returns a member from a prior period in the same relative position as a specified member.



  • Member_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a member
  • Level_Expression
    A valid PEL expression that returns a level
  • Index
    A valid integer expression that specifies the number of parallel periods to lag

Return value

This function returns the parallel period of the specified member among the descendants of the sibling.


Although similar to the Cousin (PEL) function, the ParallelPeriod function is more closely related to time series. The ParallelPeriod function takes the ancestor of Member_Expression at Level_Expression and finds the sibling of the ancestor with the specified lag.

The ParallelPeriod function is equivalent to the following PEL statement.


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


Cousin (PEL)
SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN