Solved
Using Memberlists in Finance BR
Hi I have created a member list on Account dimension members to pull accounts with Account type "Balance Recurring". Now I need to use this member list in Finance BR - Calculate Function Type to l...
Forum Discussion
I built the below code to get the list of Balance Recurring Accounts and Store it to the Globals.I am running this rule for a single entity and assigning the Globals.SetObject within the scope of "Global" Entity.
Now when I run the Globals.GetObject on other entities it doesn't pull the list of members. It didn't work when I moved the Globals.SetObject outside of the scope of "Global" Entity as well.
It is retrieving the members only when it is run for "Global" Entity.
Any pointers would be appreciated if I am missing something.
'**********************************************************************************************************************
Dim BR_AccountList As List(Of String)
Dim BR_AccountMember_Name As String
If POVENTITY = "Global" Then
Dim BR_AccountList_Info As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(api.Dimensions.GetDim("RevPlan_Accounts").DimPk, "A#Root.Base.Where(AccountType = 'BalanceRecurring')", Nothing)
If (Not BR_AccountList_Info Is Nothing ) Then
BR_AccountList = New List(Of String)
For Each BR_AccountMember As MemberInfo In BR_AccountList_Info
BR_AccountMember_Name = BR_AccountMember.Member.Name
BR_AccountList.Add(BR_AccountMember_Name)
Next
End If
Globals.SetObject("BR_AccountList_Global" , BR_AccountList)
End If
Dim BR_AccountList_Global As List(Of String) = Globals.GetObject("BR_AccountList_Global")
If POVENTITY = "S0001" Then
For Each GlobalMember As String In BR_AccountList_Global
api.LogMessage("Member :" & GlobalMember)
Next
End If