HFM Consolidation Time varies across Environment
After doing complete analysis across our environment we found that in our CFG (Config) Environment it took 2 hours for consolidation however for other environment DEV/TEST it takes 4 hours.
We have copied the same application across the environment and doing the consolidations (Consolidate All) for same POV.
CFG Environment Details
=======================
Tuning Parameters:
Created 4 Registry Keys in
[HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Server]
MinDataCacheSizeInMB set to 2000
MaxDataCacheSizeInMB set to 4500
MaxNumDataRecordsInRAM set to 30000000
NumConsolidationThreads set to 8
Even though after that there is no changes in the consolidation timings it is taking the same time.
Hardware Details
=================
CFG Environment: CPU with 2 Cores and 8 GB RAM