Forum Discussion

OlofA's avatar
OlofA
New Contributor II
10 months ago

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
    10 months 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
10 months 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)