Forum Discussion

mgreenberg's avatar
mgreenberg
Contributor II
19 days ago

Mapping IC based if account is IC

We want to set the IC value to none if an account is not IC.  We are currently doing this in the IC dimension in the datasource and looking up the account, getting the target and then checking If IC....
Transformation
MarcusH's avatar
MarcusH
Valued Contributor
14 days ago

We look up the IsConsolidated property for the Target account using a BR like this:

Dim tgtAcc As String = args.GetTarget("A#")
Dim tgtAccID As Integer = BRApi.Finance.Members.GetMemberId(si, DimTypeId.Account, tgtAcc)

Dim isICAcc As Boolean = BRApi.Finance.Account.IsIC(si, tgtAccID)

If isICAcc = False Then
    Return "None"
Else
    Return args.OutputValue
End If

You will need to check that Dimension Transformation Sequence processes the Account dimension before the IC dimension (Application | Cubes | cube | Integration).