UniqueName (PQL)

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

UniqueName( <Hierarchy> )

or

UniqueName( <Level> )

or

UniqueName( <Member> )

Syntax Alternatives

<Hierarchy> .UniqueName()

or

<Level> .UniqueName()

or

<Member> .UniqueName()

* 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