HasChildren (PQL)

Determines if the hierarchical member has child members

  • Returned Output: Boolean
  • Library: PQL \ Semantic \ Logical
  • Version: 2020.20.000
  • Compatibility: Pyramid Query Language (PQL) data sources

Syntax

HasChildren( <Member> )

Syntax Alternatives

<Member> .HasChildren()

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

Comments
  • The function ONLY works for members that are part of a multi-level hierarchy.
Different Function types
  • This function is similar to the MDX HasChildren function.

Examples

This example returns "true" for bikes in the product hierarchy.

Haschildren([products].^[products Hierarchy].[Bikes])

This example returns "False", since this bike is at the bottom of the hierarchical tree.

[products].^[products Hierarchy].[Bikes].[Mountain Bikes].[Mountain-100 Black, 38].Haschildren()