Level (PEL)

  • Article

This function finds the level of a specified member.

Member_Expression.@Level

Parameters

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

Return Value

The Level function returns the level of a specified member.

Remarks

This function can be used only in a leveled hierarchy.

Because Level is a PEL keyword, when you use this function, you must precede the word Level with the at symbol (@), as in @Level.

The PEL compiler can generate SQL code for this function when the function is a part of an absolute reference. The compiler cannot generate SQL code when the function is a part of a relative reference.

See Also

Reference

SQL generation for PEL functions

Other Resources

PEL reference