Hi
Have you done any error logging to check whether the system is executing this calculation on the expected data units? Where is this calculation included (i.e. member formula, business rule, custom elimination script)?
Regards,
Thank you for the reply, Karl.
The calculation of the Intercompany Minority Interest is done via member formula and is triggered by a spesific value (Custom1) in the "Ownership Type" property of the partially owned entity. The amount is being correctly calculated and correct IC partner is being assigned. However the IC elimination is not happening for this amount at the first common parent level and we are struggling with why.
We do not use custom elimination logic, relying instead on the standard IC elimination functionality, which works fine in all the other cases.
I looked through both error log and task log and I cannot see anything related to the issue. However, I might not be technically savvy enough to understand the logs completely.
Okay - If i'm understanding you correctly, your member formula in the screen shot above is executing and you want the results of that to then be eliminated later at the common parent?
If that's the case, i suspect the issue is that you're writing the result to O#Elimination. I don't believe this will be picked up by the standard consolidation for eliminations.
regards,
Thanks again, Karl.
I've tried changing the Origin setting for my calculation to "Import", "Forms" and "AdjInput". If it is set to anything other then O#Elimination, the balance is not calculating at all.
Imports System
Imports System.Data
Imports System.Data.Common
Imports System.IO
Imports System.Collections.Generic
Imports System.Globalization
Imports System.Linq
Imports Microsoft.VisualBasic
Imports OneStream.Shared.Common
Imports OneStream.Shared.Wcf
Imports OneStream.Shared.Engine
Imports OneStream.Shared.Database
Imports OneStream.Stage.Engine
Imports OneStream.Stage.Database
Imports OneStream.Finance.Engine
Imports OneStream.Finance.Database
Namespace OneStream.Formula
Public Class MainClass
Public Sub Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api as FinanceRulesApi, ByVal args as FinanceRulesArgs)
Try
'XFFormula
'July 18th, 2024, Yan Savinsky. First Version
If (api.Cons.IsRelationshipLevel And api.Entity.OwnershipType().ToString = "Custom1")
'If ((api.Cons.IsRelationshipLevel) And (api.pov.Cons.Name = "Elimination") And (api.Entity.OwnershipType().ToString = "Custom1"))
Dim entityID As Integer = api.POV.Entity.Memberpk.Memberid
Dim parentID As Integer = api.POV.Parent.Memberpk.Memberid
Dim pOwn As Decimal = api.Entity.PercentOwnership(entityID, parentID)
' Dim entityName As String = api.Pov.Entity.Name.ToString
Dim entityName As String = api.Entity.Text(8)
' api.Data.ClearCalculatedData("C#Elimination:A#399600_IC:F#EndBalCalc:O#Elimination",True,True,True)
api.Data.Calculate("C#Elimination:A#399600_IC:F#EndBalCalc:I#" & entityName & ":O#Import = C#Local:A#EquityToCommon:F#EndBalCalc:I#None:O#Top * " & (1 - pOwn/100))
End If