Forum Discussion
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.
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
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).
4 Replies
- T_Kress
OneStream Employee
You can pull descriptions using the below syntax:
=XFGetMemberInfo("Property","Dimension","MemberName")
It will pull descriptions in the culture code of the user.
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
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
- 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).
