TopPercent (PEL)

  • Article

This function sorts a set in descending order and returns a set of members for which the cumulative total with the highest value is equal to or less than a specified percentage.

TopPercent(
    Scope_Expression,
     Percentage,
     Numeric_Expression
      )

Parameters

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

Return value

The TopPercent function calculates the sum of Numeric_Expression members evaluated over Scope_Expression, sorting the set in descending order. The function then returns the topmost MemberSet whose cumulative percentage of the total summed value is at least the specified Percentage.

This function returns the smallest subset of a set whose cumulative total is at least the specified percentage. 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

BottomPercent (PEL)

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN