IsSibling (PQL)

Returns whether a specified member is a sibling of another specified member.

Syntax

IsSibling( <Member> , <Member> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The member needs to be the unique name of an existing member in a regular hierarchy.
  • The function will not work on drill-path hierarchies.
  • For details on how to employ and use this function see the semantic calculation overview.
Parameters
  • member1: The first member in the hierarchy.
  • member2: The second member in the hierarchy.
Returns

The function returns a boolean value:

  • TRUE if both members share the same parent (i.e., they are siblings).
  • FALSE if they do not share the same parent.
Different Function types
  • This function is like the MDX IsSibling function.

Examples

The IsSibling function is used to determine whether two members in a hierarchy are siblings, meaning they share the same parent.

IsSibling([Products].^[Products].[Accessories].[Bike Racks],[Products].^[Products].CurrentMember)

You can see the effect from this example snippet in column #4- IsSibling, based on the source column in position #1: