Ordinal (PEL)

  • Article

This function determines the zero-based integer value associated with a level.

Level_Expression.Ordinal

Parameters

  • Level_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a level.

Return Value

Returns an integer that corresponds to the depth of the specified level. The shallowest level possible is 0.

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

See Also

Reference

SQL generation for PEL functions

Other Resources

PEL reference