Consolidation stopped working
The client's consolidation stopped working on their top member after a specific point of time. From their earliest data point through 2023M11, it works fine. From 2023M12 forward it will consolidate ...
Forum Discussion
Henning
OneStream Employee
OneStream EmployeeHi Michel,
What I always do in such a case is to follow the data step by step to locate the exact spot where it goes "missing". That means checking...
- local currencies on base entities to verify the data has been loaded
- translated currencies on base entities to verify the data has been translated
- C#Share on base entities to verify the data has been correctly aggregated to this member
- etc. until you are at C#Top and then you repeat this for each parent level entity until you found the C# member and entity combination.
Once you located this, you then drill into the details.... Origin dimension, flow dimension, audit dimension etc. until you know where the data stops aggregating or maybe moved to a different member. Once you found that point, it is usually obvious where it went wrong.
Hope that helps!
What's really strange is that I've done this, and it all aggregates and translates as expected until it gets to the top entity. Its direct children (which includes translation to USD) all are rolling up correctly. It's only not rolling up to the top parent, and only for certain periods. Still digging, but I'm perplexed at this point