IsAncestor (PQL)
Returns whether a specified member is an ancestor 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.
Different Function types
- This function is like the MDX IsAncestor function.
Exampless
IsAncestor([Products].^[Products].[Bikes], [Products].^[Products].CurrentMember)
Parameters
- [Products].^[Products].[Bikes]: The member you want to check if it is the ancestor.
- [Products].^[Products].CurrentMember: The member you want to check if it has the specified ancestor.
Returns
The function returns a boolean value:
- TRUE if ancestor_member is indeed an ancestor of descendant_member.
- FALSE otherwise.
You can see the effect from this example snippet in column #2- isbike, based on the source column in position #1:
