IsSibling (PQL)
Returns whether a specified member is a sibling of another specified member.
- Returned Output: Boolean
- Library: PQL \ Semantic \ Hierarchical
- Version: 2023.00.000
- Compatibility: Pyramid Query Language (PQL) data sources
Syntax
* 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: