BottomCount (PEL)

  • Article

This function sorts a group of members in ascending order and returns the specified number of members in the group with the lowest values.

BottomCount(
     Scope_Expression,
     Count 
      [ , Numeric_Expression ]
      )

Parameters

  • Scope_Expression
    A valid PerformancePoint Expression Language (PEL) scope expression.
  • Count
    A valid integer expression that specifies the number of members to be returned.
  • Numeric_Expression
    A valid numeric expression that is typically a PEL expression of cell coordinates that return a number.

Return value

If successful, this function returns Count members in Scope_Expression.

Remarks

If a numeric expression is specified, this function sorts the members in the specified scope according to the value of Numeric_Expression, as evaluated over the member sets in the scope, in ascending order. The BottomCount function then returns the specified Count of members with the lowest value.

If a numeric expression is not specified, the function returns the set of members in natural order, without any sorting.

The PEL compiler cannot 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

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN