Forum Discussion

CarlosAlvear's avatar
CarlosAlvear
Contributor
2 days ago
Solved

Get member description in user's culture code using excel add-in

Hi all, Do you know how to get the member description in a scpecific language using the Excell add-in? I suppose that it can be done using the "XFGetMemberProperty" but I can't find an example. Tha...
Excel Add In
Reports
  • T_Kress's avatar
    T_Kress
    2 days ago

    So you are saying a user wants to see a description other than what their culture in their user ID is set to?  If so, then yes, you have to do a dynamic calc as Robin mentions in this thread.

    Excel will only return the descriptions based on the user's culture (fr-fr or it-it or US-en, etc).  

CarlosAlvear's avatar
CarlosAlvear
Contributor
2 days ago

Thank you T_Kress​ , but how can you see a description that doesn't belong to the user culture? for instance "fr-fr" or "it-it" if by default is "US-en"?

Thank you.

Best regards

Carlos

rhankey's avatar
rhankey
Contributor II
2 days ago

If you don't mind using a dynamic calc member to retrieve the cultural descriptions, then you can get at the cultural descriptions with either of these options:

Dim CulturalDescriptions As List(Of MemberDescription)=BRApi.Finance.Members.ReadMemberDescriptionsNoCache(si,DimType.Account.Id,MemberId)

Or, if you have retrieved the MemberInfo for the member in let's say X, then:

Dim Dictionary Of(String, MemberDescription)=X.Descriptions