Skip to main content
C
CarlosAlvear
May 20, 2025
Solved

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

  • May 20, 2025
  • 2 replies
  • 1 view

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.

Thank you.

 

XFGetMemberProperty
This function retrieves any Dimension Member property from the Member Properties tab in the Dimension Library. Note there are no spaces used when defining property name.
XFGetMemberProperty(“DimTypeName”,“MemberName or Script”,“PropertyName”, “VaryByCubeTypeName”,“VaryByScenarioTypeName”,“VaryByTimeName”) 

As a reference when using BR: Get member description in user's culture code | OneStream Community

Best regards,

Carlos

Best answer by T_Kress

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).  

2 replies

T
T_Kress
May 20, 2025

You can pull descriptions using the below syntax:

=XFGetMemberInfo("Property","Dimension","MemberName")

It will pull descriptions in the culture code of the user.

 

C
CarlosAlvearAuthor
May 20, 2025

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

R
rhankey
May 20, 2025

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

 

 

Terms & ConditionsAccessibility statement