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. .