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)