UniqueName
Returns the unique name of a specified level or member.
- Returned Output: Text
- Library: PQL \ Semantic \ String
- Version: 2020.10.000
- Compatibility: Pyramid Query Language (PQL) data sources
Syntax
or
or
Syntax Alternatives
or
or
* Click on the function's arguments above for more details on the input values.
Comments
- When using the hierarchy name alone, it assumes the current member .
- For details on how to employ and use this function see the semantic calculation overview.
Different Function types
- This function is like the MDX uniquename function.
Examples
This example returns the string "[Customer].[State].[New York]", since it the current member in the state hierarchy.
UniqueName([Customer].[State])
This example returns the string "[Date].[year].[2020]", by finding the member that is 2 steps ahead of 2018 in the year hierarchy.
Lead([Date].[year].[2018], 2).UniqueName
This example returns the string "[Customer].^[geo hierarchy].^[State]", since State is the second level in the Geo Hierarchy after country.
[Customer].^[geo hierarichy].Levels(2).UniqueName