Skip to main content
O
OlofA
March 15, 2024
Solved

Retrieve field value for account dimension member

  • March 15, 2024
  • 2 replies
  • 1 view

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!

Best answer by RobbSalzmann

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

R
RobbSalzmannAnswer
March 15, 2024

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)

 

B
BobNelson
March 15, 2024

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