Infor.Get.Element.Attribute Formula Help in Excel

Charlie_Geddes · 2025-07-09T13:54:15+00:00

There was an error rendering this rich post.

Hoping somebody can help me with the Infor.Get.Element.Attribute formula. Is it possible to use this formula to retrieve an element's Member_Unique_Name if I know the Member_Name? I can retrieve the unique name if I already know the unique name, but the formula returns a blank if I only know the member name. I have unsuccessfully tried both Infor.Get.Element and Infor.Get.Element.Attribute, and I feel like I have made this work in the past, but I'm struggling at the moment.

My current solution for retrieving an element's unique name is to search for the element using its name or ID in the Add Horizontal Elements or Add Vertical Elements feature. Is there anything else I should try in order to pull the unique name?

I have copied my formula below. B2 is the Data Connection, B3 is the Cube, B22 is the Hierarchy, and M15 is the element I'm searching for.

=INFOR.GET.ELEMENT.ATTRIBUTE($B$2,$B$3,"MEMBER_UNIQUE_NAME",$B$22,M15)

The formula works when M15 = [GP_PROFIT_CENTER].[0].[5].[51].[510].[5100].[51000].[510002], but not when M15 = 510002

Thank you in advance!

Find more posts tagged with

FAQs, How-To, and Best Practices

Accepted answers

All comments

Peter Chapman

you need to format the M15 cell data as [Dimension].[Element]

you can use shortened code if single hierarchy as [GP_Profit_Center].[510002]

or use formula in cell to generate it - ="[GP_Profit_Center].["&CellRef&"]"

Vit Holy

I am afraid it is not that easy. It depends if the Caption is really same as the last part of the UN. You don't need to provide even the first part, it is just fine to use the last part of UN.

This is working (because last par to of UN is same as Caption):

This is not working (because it is different, UN part is Car Tires All Season):

With some models it will work fine, with some not.

@Charlie_Geddes this will need some ER I think and I'll see what we can do about it.

Charlie_Geddes

Thank you, Vit and Peter! The [] brackets were what I was missing, and once I modified my formula like you guys suggested, I was able to retrieve the unique name.

Vit, I cannot think of any instances where a member name is not the same as the last part of the unique name, so I think this approach will work for us. If I run into any of these situations, I will circle back and open an ER.

Copyright © 2025 Infor. All rights reserved.