- 3,733,802 Users
- 2,246,823 Discussions
- 7,856,879 Comments
- 17.8K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 57 Insurance
- 533.2K On-Premises Infrastructure
- 137.3K Analytics Software
- 38.5K Application Development Software
- 5.1K Cloud Platform
- 109K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.7K Infrastructure Software
- 105K Integration
- 41.5K Security Software
Relative speed of second Consolidate All With Data
We have a rollup that needs to be consolidated twice because some parent entity balances need to be written to a few corporate base entities.
After loading data, the second Consolidate All with Data is much, much faster than the first Consolidate All with Data. This has never struck me as strange, but I was wondering about the actual mechanics of why it is so much faster. If we are running a CAWD the second time, then the rules should be running on all entities again and impacting the entities all the way up the hierarchy.
Is the second consolidation's relative speed because the vast majority of balances are not changing, and the parent entity balances do not actually have to be written again? i.e. the base entities are re-calculated, but when those balances are rolled up to a parent entity, HFM "sees" that the parent entity balances are unchanged, and does not actually take the time to overwrite the balances that are already there?
Any insight would be appreciated.