Single-currency consolidations
These three items can improve single-currency consolidation performance. For more information on the parameters mentioned here, see the "Consolidation engine" chapter.
- If you do not report on local currency, you should set the consolidation request DoLocalAuto parameter to 0.
- Set the MaxOSRCacheRecords parameter to a setting that is higher than the total number of members on your largest schedule.
- Change the CrossProductThreshold parameter setting to reflect a reasonable value for your database size. Lower the setting for a sparse database. Raise the setting for a dense database. .