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
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
OneStream EmployeeIt could be a number of things. I would check the scenario settings in conjunction with how you're loading your data. I described the settings in the blog post here: https://community.onestreamsoftware.com/t5/ONECommunity-Blog/Making-sense-of-the-Scenario-settings/ba-p/14974
Thanks Chul - the post was very helpful!
I did find out how its calculating the YTD amounts - OneStream is summing the product of the periodic amounts and the consolidation percentages for each period. Its showing the correct YTD and periodic amounts for every month we have actuals - so our remaining issue is for the remainder of the year (Jun-Dec) and only on the structures that were updated, there are derived amounts on the parents that are the sum of the periodic amounts for Jan-May. Our No Data Zero View for Non Adjustments on the Actual scenario is set to YTD, so the base and child members of the hierarchy are summing up to zero in Jun with the derived amounts, except for the parents where the percent consolidation stored item is applied. What would cause the YTD amount to not equal zero for Jun-Dec in this situation?
- chul
I'm not completely sure I understand your question - a screenshot of the situation would help if you're able to provide one.
