Get the unique name of an element of a specific top element

lindenbauer-michael

Dear all,

we are faced with following problem.
We have a dimension with following structure (see down below). Is there a possibility / formula to get the unique name of an element of a specific top element / node? There is only the caption of the element available.

Dimension DTIME
[DTIME]
- All
- 01.2022
- 02.2022
...
- ROL
- 01.2022
- 02.2022
...

Example:
Caption: "01.2022"
Short unique name: "[DTIME].[01.2022]"
Formula: =ROA(Alias;Cube;"[DTIME]";"MEMBER_UNIQUE_NAME";"[DTIME].[01.2022]")
Result "[DTIME].[All].[01.2022]"

Question: How to get "[DTIME].[ROL].[01.2022]"

This is only a very simplified example.
We use V11. We know the "hierarchy" concept, but it isn't applied in this dimension and also not an option for us.

Thanks in advance.
Kind regards,
Michael Lindenbauer

peter-kriebernegg

Hi Michael,

this issue has alsoalready been raised by one of my clients as an Enhancement, but not yet found into the software.

"Function to read out Parent Unique Name of a special hierarchy (When having parallel hierarchies in OLAP Dimension)"
https://ers.infor.com/ERS/Ers_Details.aspx?tbv=1&erID=7779

Am I right?

Kr,

Peter