Except (PEL)

  • Article

This function evaluates two MemberSets and returns a MemberSet that is generated by removing the members of the first MemberSet that also exist in the second MemberSet.

Except(
      MemberSet_Expression1,
      MemberSet_Expression2
      )

Parameters

  • MemberSet_Expression1
    A valid PerformancePoint Expression Language (PEL) expression that returns a MemberSet.
  • MemberSet_Expression2
    A valid PEL expression that returns a MemberSet.

Return values

This function removes members from MemberSet_Expression1 that also exist in MemberSet_Expression2.

Remarks

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

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN