Hello Everyone!Is there any function to get the Unique Name of a specific element using Element Caption in Application Studio?For example:MEMBERNAME function seems to accept "Element Name" as parameter not "Element Caption".Thanks,Jerome
Depends on your usage, there are several ways. Personally I find myself using MEMBERGET most often. You could also use ROA. But if you only have the caption value to work with you may have to do a bit more than this.
Not sure if this is most elegant way but you could use something like following ROA formula =ROA(GlobalVariables.gv_Alias_OLAP_User.Text,GlobalVariables.gv_Cube_TFINANC.Text,"[DCOMPC]","MEMBER_UNIQUE_NAME","[DCOMPC].["&<<CAPTION>>&"]")
Careful, this will work only if your "caption" is the technical name of the element. If you are "really" working with caption, then this will not produce a result. In fact, you could have multiple elements with the same caption - so from a puristic view, it is impossible to retrieve a unique name from a caption. Only from the technical element name.
Hi Matthew, Thanks for the quick response! I tried to use MEMBERGET but i'm getting the fist top level node instead of the desired node. =MEMBERGET("FSM","GLTOT","[GLTOT_Scenario]","[GLTOT_Scenario].[1].[FY2023 Budget]","Self")I'm trying to get the "Unique Name" of "[GLTOT_Scenario].[1].[FY2023 Budget]"where "FY2023 Budget" is the caption.Here is the Database Structure:
And here is the data preview:What i was trying to supply as parameter is the Element Caption and what i need to get is the Element Unique Name.Btw, here is the error log:[02:59:46.608][# 40][ 25] The unique name [GLTOT_Scenario].[1].[FY2023 Budget] could not be resolved.[E][02:59:46.608][# 40][ 25] The unique name [GLTOT_Scenario].[1].[FY2023 Budget] could not be resolved.[E][02:59:46.608][# 40][ 25] 0 -> SoapException: The unique name [GLTOT_Scenario].[1].[FY2023 Budget] could not be resolved.[E][02:59:46.608][# 40][ 25] Stack Trace:[E][02:59:46.608][# 40][ 25] at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)[E][02:59:46.608][# 40][ 25] at System.Web.Services.Protocols.SoapHttpClientProtocol.EndInvoke(IAsyncResult asyncResult)[E][02:59:46.608][# 40][ 25] at Infor.BI.Common.XmlaClient.Driver.XmlaProxy.EndExecute(IAsyncResult asyncResult)[E][02:59:46.608][# 40][ 25] Thanks,Jerome
Hi @filip-kosnac , was the "MEMBER_UNIQUE_NAME" is the name of the unique element attribute? In my case, there's no "Unique Element" defined on the attribute:
However, there's a Unique Element showing on preview, was that fixed for every cubes?Sorry if you find this ****, i'm just new to FSM / Infor BI.Btw, i'm getting #NA! error..=ROA("FSM","GLTOT","[GLTOT_Scenario]","Element Unique Name","[GLTOT_Scenario].[1].[FY2023 Budget]")
MEMBER_UNIQUE_NAME is built in Attribute and represents "Element Unique Name".If you use ROA or Memberget, you must use MEMBER_UNIQUE_NAME instead of "Element Unique Name".
I tried both of the below formula, but unfortunately, still not working:=ROA("FSM","GLTOT","[GLTOT_Scenario]","MEMBER_UNIQUE_NAME","[GLTOT_Scenario].[1].[FY2023 Budget]")=ROA("FSM","GLTOT","[GLTOT_Scenario].[1]","MEMBER_UNIQUE_NAME","[GLTOT_Scenario].[1].[FY2023 Budget]")
it was returning #NA!
