Lead (PEL)

  • Article

This function returns the member that has the index number of members after a specified member along the same level.

Member_Expression.Lead( Index )

Parameters

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

Remarks

This function is defined as Member_Expression.Lag(-Index). For detailed reference information, see Lag (PEL).

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

Lag (PEL)
SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN