Generate (PEL)

  • Article

This function applies a set to each member of another set and then joins the resulting MemberSets by union.

MemberSet_Expression1.Generate(
      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 value

The Generate function returns a MemberSet that is generated by applying MemberSet_Expression2 to each member in MemberSet_Expression1. Then the function joins the resulting sets by union.

Remarks

The Generate function iterates over each member in MemberSet_Expression1. For each element in MemberSet_Expression1, Generate adds every element specified by MemberSet_Expression2 into the result set.

Generate is most powerful when MemberSet_Expression2 is an expression that conditionally depends on MemberSet_Expression1. This can occur when MemberSet_Expression2 uses the CurrentMember (PEL) function.

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

SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN