TopSum (PEL)

  • Article

This function sorts a MemberSet and returns the topmost elements whose cumulative total is at least a specified value.

TopSum(
     Scope_Expression,
    Value,
    Numeric_Expression
     )

Parameters

  • Scope_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a set
  • Value
    A valid real expression that specifies the value against which the cumulative total is compared
  • Numeric_Expression
    A valid numeric expression that is typically a PEL expression that returns a measure

Return value

The TopSum 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 topmost elements whose total is at least Value.

This function returns the smallest subset of a set whose cumulative total is at least the specified value. The returned elements are ordered largest to smallest.

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

Reference

BottomSum (PEL)

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN