The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

OlofA's avatar
OlofA
New Contributor II
2 years ago
Solved

Retrieve field value for account dimension member

Hi, I'm trying to retrieve the value of the field "Text - Text 8" for an account dimension member. What formula should I use to get this value? Thank you in advance!
Finance
  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    In a rule/XFBR:

    'Dim sValue As String    = BRApi.Finance.Account.Text(si, memberId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId)
Dim text8Value As String = BRApi.Finance.Account.Text(si, 1002,     8,                 900100,               2022009000)

    in a cubeview:

    XFMemberProperty(DimType=Account, Member=NetIncome, Property=Text8)

     

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

In a rule/XFBR:

'Dim sValue As String    = BRApi.Finance.Account.Text(si, memberId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId)
Dim text8Value As String = BRApi.Finance.Account.Text(si, 1002,     8,                 900100,               2022009000)

in a cubeview:

XFMemberProperty(DimType=Account, Member=NetIncome, Property=Text8)