BottomPercent (PEL)

  • Article

This function sorts a MemberSet in ascending order and returns the bottom-most MemberSet whose cumulative total is at least a specified percentage.

BottomPercent(
     Scope_Expression,
     Percentage,
    Numeric_Expression
      )

Parameters

  • Scope_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a scope.
  • Percentage
    A valid integer expression that specifies the percentage 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 Values

The BottomPercent function calculates the sum of Numeric_Expression, evaluated over Scope_Expression, sorting the set in ascending order. The function then returns the bottom-most elements whose cumulative percentage of the total summed value is at least the specified Percentage.

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