The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
benmac360
3 years agoNew Contributor III
Incorrect Consolidated Data
Hello - we recently updated the stored values in the Percent Consolidation property in several large entity hierarchies, so there are 3 stored items with different time periods for each child. We fou...
chul
OneStream Employee
3 years agoIs there a reason why you're trying to validate future months that haven't had loaded data? Or is this more of a "why is this data being calculated" question? I ask because you've stated that you've "corrected" the future months by force consolidating but it's no longer working.
If it's "why is this data being calculated", my hunch is that the business rules you've got running are looking at the derived data and calculating ownership based on those values. So even though you haven't loaded data to June, the derived data shows a periodic change of 923k.
If your issue is strictly presentation, you can return zero (or whatever value you want) for the future months in a CV using an XFBR rule or possibly conditional formatting (if it's a future month, text color = transparent).
- benmac3603 years agoNew Contributor III
Yes, that's correct, its a question of why are we seeing these amounts in future months just for these 3 structures. I'll have our business rules reviewed, see if any recent changes were made. Thanks for your help!
Related Content
- 3 years ago
- 3 years ago
- 3 months ago