Forum Discussion

HoneyGulati's avatar
HoneyGulati
New Contributor III
19 hours ago

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) to make the process faster?

We have a reporting application with huge set of data and need to refresh the data hourly followed by consolidation which is time consuming process. I am using data management out of the box step for consolidation with C#Aggregated. Can I use any other approach to make it faster?

 

Consolidation

2 Replies

  • MikeG's avatar
    MikeG
    Contributor III
    12 hours 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.