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)

     

2 Replies

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

     

  • BobNelson's avatar
    BobNelson
    New Contributor III
    2 years ago

    Interesting solution.  I might have created a ud8 member with a formula attached to it so as to retrieve and display the text value in a column of a cube view.