BottomSum (PEL)

This function sorts a specified MemberSet in ascending order and returns the bottom-most set of members whose sum is equal to or less than a specified value.

BottomSum(
     Scope_Expression, 
     Value, 
     Numeric_Expression
  )

Parameters

  • Scope_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a set.
  • Value
    A valid numeric expression that specifies the sum against which the cumulative total is compared.
  • Numeric_Expression
    A valid numeric expression that is typically a PEL expression of cell coordinates that return a number.

Return Values

The BottomSum function calculates the sum of the specified Numeric_Expression members evaluated over Scope_Expression, sorting the set in ascending order. The function then returns the bottom-most elements whose cumulative total**is at least the specified Value (sum).

Remarks

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