Formula to get unique name of a specific element in Application Studio

Dear all,

is there a formula to get the unique name of a specific element in Application Studio? I know there is MEMBERNAME, but it doesn't work as expected.
Following situation - Dimension DCOSTC looks like that:

[DCOSTC]
[DCOSTC].[Total]
[DCOSTC].[Total].[100_1111]
[DCOSTC].[Total].[100_1112]
[DCOSTC].[100]
[DCOSTC].[100].[100_1111]
[DCOSTC].[100].[100_1112]
[DCOSTC].[PRD]
[DCOSTC].[PRD].[100_1111]

E.g. I would need a way to get unique name of an element of branch [DCOSTC].[100]. I only have caption of element 100_1111.
If I use =MEMBERNAME("CPM"; "TCONTROL"; "[DCOSTC]"; "[DCOSTC].["$C12&"]") in a hyperblock I get in some cases [DCOSTC].[PRD].[100_1111] and in other [DCOSTC].[100].[100_1112].

KR
Michael

Find more posts tagged with

Infor EPM Discussions

Comments

unknown

Hey Micheal,

How are you retrieving the element caption in the first place?

OLAP objects contain both the unique name and caption properties, eg hyperblock can be configured to display caption but contain unique name within the cell (by default).
list views can display caption or unique name (and attributes if needed) by changing the extension of the list view such as: listview1.text - unique name

listview1.alias - caption

Alternatively you can build a unique name with simple string concatenation:

=“[Dimension].[“&CAPTION&”]”

Hope that helps

Ibrahim

lindenbauer-michael

Hallo Ali,
thanks for your response - unfortunately that doesn't help.
In the hyperblock we have a relational list, so I only get the caption.
I need the full unique name as in a further action this is saved to a global variable, which is input of a ListView.

KR
Michael

unknown

I see, use Memberget; "self" for unique name of passed element. You can also retrieve child, parent etc with this formula.

jens-marburger

combine

memberget( Self,“[Dimension].[“&ELEMENTNAME&”]”) to get the full UN with complete hierarchie information. Workaround to get the wanted hierarchie maybe use a listview, which is filtered by structure "element underneath.." and put in a variable for filter the correct element.

HtH

Peter Mayall

You could change your OLAP database settings to use the "Short" format instead of the default "Long" format. The "Short" format is "[Hierarchy].[Name].[N]" where N is the occurrence number e.g. "[DCOSTC].[100_1111].[1]".

The problem with this is that you will probably end up breaking a number of reports that have already been written but this could be a better long term solution for you.

peter-kriebernegg

Hi,

for me this sounds like a problem/situation also some of my clients aready asked.

I added this as an ERS, which was (unfortunately) ignored until now.

"Feature to read out Member_Unique_Name of a specified Hierarchy"

https://ers.infor.com/ERS/Ers_Details.aspx?tbv=1&erID=45641

Kr,

Peter

lindenbauer-michael

Hi Peter,
unfortunately ERS can not be endorsed anymore, as time is up.

But yes, that's what we needed. To get a UNIQUE_NAME of an element of a specified Hierarchy (or top element).
By the way, we solved the topic, we used a relational help function, as we didn't manage to get it done in OLAP data model.

KR
Michael

Copyright © 2025 Infor. All rights reserved.