AllMembers (PQL)

Returns a list of every element from the specified hierarchy / attribute or level.

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

Syntax

AllMembers( <Hierarchy> )

or

AllMembers( <Level> )

Syntax Alternatives

<Hierarchy> .AllMembers()

or

<Level> .AllMembers()

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

Comments
  • The hierarchy name needs to be its unique name in the format: [dimension].^[hierarchy] or [table].[column].
  • The level name needs to be its unique name in the format: [dimension].^[hierarchy].^[level].
  • For details on how to employ and use this function see the semantic calculation overview.

This function is like the MDX "members" function - retrieving the members of the specified object.

Examples

This example with retrieves all the members in the Manufacturer attribute

AllMembers( [manufacturers].[manufacturer] )

This example with retrieves all the members in the County level of the geography hierarchy.

[Customer].^[Geo Hierarchy].^[County].AllMembers()