Forum Discussion

Emilygustavsson's avatar
Emilygustavsson
New Contributor
10 months ago

Exclude accounts from rule

Hi!

I have a business rule which allocates all PL accounts from a group of entities in one segment to other segments. However, I would like to exclude accounts that are IC from the allocation. I have classified the accounts that I would like to exclude with the text "ICElim" in box "Text 8", under "Vary by scenario type & time" in Member Properties, in the account dimension. So, in the following code string, I would like to exclude those accounts. Do you have any suggestions on how to change the code string below so that it excludes these accounts instead of picking all PL accounts?

 

Dim bIsPL As Boolean = api.Members.IsBase(api.Pov.AccountDim.DimPk, api.Members.GetMemberId(dimtype.Account.id, "PL"), cell.DataBufferCellPk.AccountId)

Finance
  • RobbSalzmann's avatar
    RobbSalzmann
    10 months ago

    Try something like this:

    Dim dimensionName As String = "All Accounts"
Dim memberFilter As String = "A#Income_Statement.Descendants.Where(Text8 <> 'ICElim')"		
Dim accountInfos As List(Of MemberInfo) = brapi.Finance.Members.GetMembersUsingFilter(si, BRApi.Finance.Dim.GetDimPk(si, dimensionName), memberFilter, True)
Dim accountNames As List(Of String) = accountInfos.Select(Function(account) account.Member.Name).ToList()

     

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    10 months ago

    Try something like this:

    Dim dimensionName As String = "All Accounts"
Dim memberFilter As String = "A#Income_Statement.Descendants.Where(Text8 <> 'ICElim')"		
Dim accountInfos As List(Of MemberInfo) = brapi.Finance.Members.GetMembersUsingFilter(si, BRApi.Finance.Dim.GetDimPk(si, dimensionName), memberFilter, True)
Dim accountNames As List(Of String) = accountInfos.Select(Function(account) account.Member.Name).ToList()