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

sfilho's avatar
sfilho
New Contributor III
3 years ago
Solved

Getting Text1 Value for Account Dimension Varying by Scenario BRApi

Good Evening, It should be something simple but apparently I am missing something. I am trying to get the Value for the Text1 field for an Account Dimension member using a Business Rule. The Text1 ...
Finance
  • Gidon_Albert's avatar
    Gidon_Albert
    3 years ago

    Did you try BRApi.Finance.Account.Text ?

    for example: 

    'Get the member ID for the Cash account, 5 is the Account dimension dim type	
Dim memberID As Integer = BRApi.Finance.Members.GetMemberId(si, 5, "Cash")		

'Get the Text1 value for the default scenario type and time. The two "-1" are the defaults scenario dim type and time. 	
Dim acctText1 As String = BRApi.Finance.Account.Text(si, memberId, 1, -1, -1)

     

NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

Hello, Try this please

 

Dim lstBaseAccounts As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(api.Pov.AccountDim.DimPk, "A#[Root].DescendantsInclusive")
If lstBaseAccounts.Count > 0 Then

For Each curBaseAccount As MemberInfo In lstBaseAccounts

Dim sCurBaseAccount As String = curBaseAccount.Member.Name.ToString

Dim sText1 As String = api.Account.Text(curBaseAccount.Member.MemberId, 1)


End If

Next

sfilho's avatar
sfilho
New Contributor III
3 years ago

Hi Nidhi, thank you for the help but unfortunately the code did not work.