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