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.

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

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

4 Replies

Sort By
  • T_Kress's avatar
    T_Kress
    Valued Contributor
    2 days ago

    You can pull descriptions using the below syntax:

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

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

     

  • 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

       

       

    • T_Kress's avatar
      T_Kress
      Valued Contributor
      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).