Skip to main content
M
MarcusH
Expert
May 17, 2023
Solved

Get member description in user's culture code

  • May 17, 2023
  • 3 replies
  • 0 views

Does anyone know how to get the member description in the user's culture code?

Best answer by ChristianW

ok, you can access the descriptions with the memberinfo object:

 

Dim MemberIdOfAccount As Integer = BRApi.Finance.Members.GetMemberId(si, DimTypeId.Account, "41010")
Dim test As MemberInfo = BRApi.Finance.Members.GetMemberInfo(si, DimTypeId.Account, MemberIdOfAccount,,,New MemberDisplayOptions(True,"en-US",True,False,False,False,False,0))

BRApi.ErrorLog.LogMessage(si, test.Descriptions("en-US").Description & " " & test.Descriptions("fr-FR").Description)

 

3 replies

C
OneStream Employee
ChristianWOneStream Employee
OneStream Employee
May 17, 2023

Hi Markus

Do you need to know, how to load it? Or how to access it?

Cheers

Christian

M
MarcusHAuthor
Expert
May 17, 2023

How to access it. I am processing base members for Confirmation Rules and I want to show the user the member description in their language if it fails the Rule. I am currently using this to get the member list

Dim AllBase As List(Of Member) = api.Members.GetBaseMembers(BRApi.Finance.Dim.GetDimPk(si, UD6DimensionName), topUD6MemberID)

C
OneStream Employee
ChristianWOneStream EmployeeAnswer
OneStream Employee
May 17, 2023

ok, you can access the descriptions with the memberinfo object:

 

Dim MemberIdOfAccount As Integer = BRApi.Finance.Members.GetMemberId(si, DimTypeId.Account, "41010")
Dim test As MemberInfo = BRApi.Finance.Members.GetMemberInfo(si, DimTypeId.Account, MemberIdOfAccount,,,New MemberDisplayOptions(True,"en-US",True,False,False,False,False,0))

BRApi.ErrorLog.LogMessage(si, test.Descriptions("en-US").Description & " " & test.Descriptions("fr-FR").Description)

 

    M
    MarcusHAuthor
    Expert
    May 17, 2023

    Thank you! 

    J
    OneStream Employee
    JackLacavaOneStream Employee
    OneStream Employee
    May 17, 2023

    BRApi.Finance.Members.ReadMemberDescriptionsNoCache(si, dimTypeId, memberId) should give you all the descriptions, then you can loop through them. Each MemberDescription has a MemberDescriptionPK with a property for the language, i think.

      C
      OneStream Employee
      ChristianWOneStream Employee
      OneStream Employee
      May 17, 2023
      Dim MemberIdOfAccount As Integer = BRApi.Finance.Members.GetMemberId(si, DimTypeId.Account, "41010")
Dim list As List(Of MemberDescription) = BRApi.Finance.Members.ReadMemberDescriptionsNoCache(si, dimTypeId.Account, MemberIdOfAccount)
Dim englisch As String = list.FirstOrDefault(Function(x) x.MemberDescriptionPk.Language = "en-US").Description
Dim french As String = list.FirstOrDefault(Function(x) x.MemberDescriptionPk.Language = "fr-FR").Description
BRApi.ErrorLog.LogMessage(si, englisch & " " & french)
        W
        WernerN
        Contributor
        July 12, 2023

        I love 'Dim englisch'. Endlich ein Tip in Deutsch!
        But seriously, thank you so much for the tip. Exactly what we need to derive local account descriptions.

          Terms & ConditionsAccessibility statement