Poor Consolidation performance
SummaryConsolidation took longer to complete after migration from Legacy to Hybrid
We migrated our FCCS application from a Legacy to a new Enterprise pod. The migrated application is Hybrid enabled.
Migration was completed following the guidelines of Custom members data storage as per the Admin guide.
- Consolidation is extremely slow. It takes 4-5 hours to complete a 12 mth period consolidation at "Total_Geography" parent. In the Legay pod it took 50-60 mins.
- Running two consolidations on different scenarios extended the consolidation completion time to hours.
- There is a customised rule FCCS_10_After Opening Balance carry forward_LocalCurrency written. Removing this rule has no impact to the consolidation time which suggests the rule has been written efficiently.