Can we make consolidation process faster?

Hi HoneyGulati​ , if you can, move Entities to create more Siblings in the Entity dimension and reduce the number of Parent Entities if feasible.  OneStream processes sibling Entities concurrently.  If there are any un-necessary Parent members in the Entity dimension, such as a single Parent Entity with only 1 Base Entity, that is a detriment to consolidation speed.  Limiting the number of aggregation points in the Entity dimension would help the overall time.  Also, there are MANY ways to wreck your consolidation times.   i.e Member Formulas, long running calcs.  It begs the question of managing reasonable expectations: "It takes 30 seconds" versus "it takes 10 minutes", and what your expectations are and what is considered too slow to get the reporting hierarchies you need and want at certain aggregation points.

Hi HoneyGulati​ 

If you are already using C#Aggregated then you are already only aggregating the data e.g skipping consolidation overhead

So for any further gains, it might be worth investigating the Data Unit Size of your application, there is a KB article that explains how to do this.

OneStream Customer Support - How to Investigate and Reduce Data Unit Size

Hope this helps

Sam