Forum Discussion

HoneyGulati's avatar
HoneyGulati
New Contributor III
7 months ago
Solved

Can we make consolidation process faster?

Hi, Currently we are not using translation (currency conversion) and I was wondering if we can skip translation process while consolidating or can consolidate only specific accounts (if it allows) ...
Consolidation
  • sameburn's avatar
    sameburn
    7 months ago

    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.

    https://onestreamsoftware.service-now.com/kb?id=kb_article_view&sysparm_article=KB0013231&sys_kb_id=2ad45f932ba8a250eef0ffd16e91bfa3&spa=1

    Hope this helps

    Sam

MikeG's avatar
MikeG
Contributor III
7 months ago

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.