Leaves (PQL)

Returns the set of leaf members in the specified hierarchy.

  • Returned Output: List
  • Library: PQL \ Semantic \ List
  • Version: 2023.10.000
  • Compatibility: Pyramid Query Language (PQL) data sources

Syntax

Leaves( <Hierarchy> )

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

Comments

Leaves returns a set of leaf members for the specified hierarchy.

  • The hierarchy name needs to be a Unique Name with the format [dimension].^[hierarchy] or [table].[column].
  • For details on how to employ and use this function see the semantic calculation overview.
Different Function types

This function is like the MDX Leaves function; returning a set of all attributes belonging to a specific hierarchy.

Examples

The following example returns the set of leaf members in the customer hierarchy:

Leaves( [Customer].^[Customer Hierarchy] )