Share via

Filter (PEL)

  • Article

This function returns a scope that consists of members that are selected after the evaluation of a specified logical expression against a specified scope.

Filter(
      Scope_Expression,
     Logical_Expression
     )

Parameters

  • Scope_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a scope.
  • Logical_Expression
    A valid PEL logical expression that evaluates to true or false.

Return value

This function returns a scope by filtering against a specified scope, selecting values to return when Logical_Expression evaluates to TRUE. If no members evaluate to TRUE, an empty set is returned.

The Filter function works in a manner similar to that of the Iif (PEL) function. The IIf function returns only one of two options, based on the evaluation of a PEL logical expression. The Filter function returns a set of members that meet the specified search condition. In effect, the Filter function runs IIf(Logical_Expression, Set_Expression.Current, NULL) on each member in the set and returns the resulting set.

The PEL compiler can generate SQL code for this function when the function is part of an absolute reference. The compiler cannot generate SQL code when the function is part of a relative reference.

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

Iif (PEL)
SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN