PrevMember (PEL)

  • Article

This function returns the previous member in the level that contains a specified member.

Member_Expression.PrevMember

Parameters

  • Member_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a member

Return value

The PrevMember function returns the previous member in the same level as the specified member.

Remarks

The PEL compiler can always generate SQL code for this function.

This function is defined as Member_Expression**.Lag(1)**. For more information, see Lag (PEL).

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

Lag (PEL)
SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN