DefaultMember (PQL)

Returns the default member of the measures hierarchy.

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

Syntax

DefaultMember( <Hierarchy> )
Syntax Alternatives

<Hierarchy> .DefaultMember()

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

Comments
  • The defaultmember function ONLY works for Measures. It is not applicable to any other hierarchy in PQL.
Different Function types
  • This function is similar to the MDX DefaultMember function.

Examples

This example returns the measure "Sales" for the Sample Demo model.

Measures.DefaultMember

This example returns the same result

DefaultMember (Measures)