Share via

Cousin (PEL)

  • Article

This function locates the child member with the same relative position under an ancestor member as a specified child member.

Member_Expression.Cousin( Relative_Member_Expression )

Parameters

  • Member_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a member.
  • Relative_Member_Expression
    A valid PEL member expression that returns an ancestor member.

Return Value

This function returns the specified member.

Remarks

This function operates on the order and position of members within levels.

To understand this function, suppose MyAncestor is a member that is an ancestor of Member_Expression and at the same level as Relative_Member_Expression. The Cousin function returns the member that has the same relative position under Relative_Member_Expression that Member_Expression has under MyAncestor.

The following example shows how this scenario might look in PEL expressions. Let

MyAncestor.FirstChild.Lead(i).FirstChild.Lead(j).FirstChild.Lead(k)

be the Member_Expression, where MyAncestor has the same level as MyRelative.

In this case, the Cousin function returns MyRelative.FirstChild.Lead(i).FirstChild.Lead(j).FirstChild.Lead(k).

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

Ancestor (PEL)
SQL generation for PEL functions

Other Resources

PEL reference
Multidimensional Expressions (MDX) Reference on MSDN