Skip to main content
OlofA
Newcomer
Mar 15, 2024 2:24 PM UTC
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!

RobbSalzmann
RobbSalzmannAnswer
Employee - Advisor
Mar 15, 2024 2:48 PM UTC

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)

 

View in thread

2 replies

RobbSalzmann
Employee - Advisor
RobbSalzmannEmployee - AdvisorAnswer
Employee - Advisor
Mar 15, 2024 2:48 PM UTC

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
    Newcomer
    Mar 15, 2024 3:51 PM UTC

    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.

      Terms & ConditionsAccessibility statement