Oscar
3 years agoContributor
C#Elimination
How does one write a calculation where the result needs to land at an intersection that includes C#Elimination. Ideally, I'd want to have a function such as:
Public Sub Book(ByVal si As Se...
The [Book] function looks like a snippet from the FSK or some consultant solution, and not part of the OneStream foundation.
I assume you want to write to C#Elimination but from a calculation that is running on another C# member. You can't write to another data unit ("push" data), you can only "pull" in Finance Rules. So instead you can test if the calculation sequence is running on the C#Elimination member by doing this:
If api.Pov.Cons.MemberId = ConsMemberId.Elimination Then
Book(si,api, "C#[SomeOtherConsMember]:" & sourceCell, "U4:[SOMECALC]", someDecimal )
End If
Thanks for the suggestion. I'm trying to address data issues / eliminations using finance business rules during consolidation to generate the necessary eliminations. There are multiple sample codes online using the some variant of the book function that is correct.