03-15-2024 10:24 AM
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!
Solved! Go to Solution.
03-15-2024 10:48 AM - edited 03-15-2024 10:48 AM
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)
03-15-2024 10:48 AM - edited 03-15-2024 10:48 AM
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)
03-15-2024 11:51 AM
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.