Forum Discussion

Hatim_Elhaouma's avatar
Hatim_Elhaouma
New Contributor II
6 months ago
Solved

Vary description vy user culture in XFBR

Hello, We are facing the following issue, we use the following xfbr to generate accounts in a cubeview rows and retrieve descriptions : XFBR(CCF_XFBR, GetCCFDrillDownWithDescription2,memberExp=[A#Ca...
cubeview
XFBR
  • Manasa's avatar
    Manasa
    6 months ago

    In your code you can use ReadMemberDescriptionsNoCache function to pull the descriptions based on the user's culture

    Dim member As String = "TrialBalance"
Dim list As List(Of MemberDescription) = BRApi.Finance.Members.ReadMemberDescriptionsNoCache(si, dimTypeId.Account, member)
Dim returnStr As String = list.FirstOrDefault(Function(x) x.MemberDescriptionPk.Language = si.Culture).Description
Return returnStr

     

T_Kress's avatar
T_Kress
Icon for OneStream Employee rankOneStream Employee
6 months ago

In the POV of the cube view you can either define a parameter and let the user pick a culture/language or you can pick current, which I believe will pick up users culture setting descriptions, if they are available:

 

Hatim_Elhaouma's avatar
Hatim_Elhaouma
New Contributor II
6 months ago

I tried using the Current option for the culture setting, but it doesn’t work because the XFBR generates a :Name() function, which seems to take precedence over the global culture settings.