Available Consolidation Settings

Before you use the Consolidation Settings module for the first time, you must run a migration configuration task to migrate the available user-created substitution variables to Consolidation Settings. See Migrating Substitution Variables to Consolidation Settings.

These consolidation settings are available for Financial Consolidation and Close.

Table 6-4 Consolidation/Translation Settings

Label Application Type Support Default Value Description

Yearly Consolidation

DSO only

Disabled

Optimize performance for multi-period consolidations

This setting is applicable if the application meets the following conditions:

  • You have two or more impacted periods and two or more hierarchy levels.

  • The impacted entities are identical across periods.

  • Equity Pickup is not enabled.

This setting is migrated from the corresponding substitution variable: Enableyearlyconsol

Optimize Custom Dimension Consolidation

DSO only

Disabled

Improve the performance of consolidation calculations for Custom dimensions.

This setting is migrated from the corresponding substitution variable: Parallelcustomdimdso

Optimize Custom Dimension Translation

DSO only

Disabled

Improve the performance of translation calculations for Custom dimensions.

This setting is migrated from the corresponding substitution variable: Parallelcustomdimtranslation

YTD FX Calculation

Applicable only for multi-currency applications.

DSO and non-DSO

Disabled

Calculate Foreign Exchange (FX) variances on a Year-to-Date (YTD) basis

Enable this setting when the default Translation Method for Flow accounts is Year-to-Date.

This setting is migrated from the corresponding substitution variable: YTDFXCalculation

YTD FX Revised

Applicable only for multi-currency applications.

DSO and non-DSO

Disabled

YTD FX Calculation Logic for Historical Accounts

If this setting is enabled, new calculated values will be generated for YTD FX Calculation Logic for Historical Accounts.

This setting is migrated from the corresponding substitution variable: YTDFXRevised

Skip Translation Rules if Entity Currency Equals Parent Currency

DSO and non-DSO

Disabled

Skip Translation Rules if Entity Currency Equals Parent Currency

Optimize Consolidation Job

DSO and non-DSO

Disabled

Enable this setting if a network error is detected during the consolidation process.

When consolidation is performed on a larger scope or when numerous jobs are done concurrently, a network error may arise due to limited computing resources. This setting ensures the best possible utilization of memory under these circumstances.

This setting is migrated from the corresponding substitution variable: OptimizeConsolidationJob

Auto Recompute Job

DSO and non-DSO

Disabled

Enable to automatically recompute ownership data during consolidation. When enabled, this setting triggers the auto recompute process during consolidation.

This setting is migrated from the corresponding substitution variable: Auto Recompute

Consolidation Job Analytics

DSO or non-DSO

Disabled

Enable this setting if you want to generate a Gen AI-based summary of time spent at various stages throughout the consolidation process.

Enable Simple Aggregation

Non-DSO only

Enabled

Optimizes the aggregation operations during the consolidation process

This setting is migrated from the corresponding substitution variable: Enablesimpleaggregation

Optimize YTD

Non-DSO only

Enabled

Optimize the YTD Calculation performance.

This setting is migrated from the corresponding substitution variable: Optimizeytdcalculation

Optimize Concurrency

Non-DSO only

Disabled

Enable this setting to take advantage of higher concurrency during consolidations. If this setting is enabled, the Opening Balance Carry Forward calculation is performed on all levels.

This setting is migrated from the corresponding substitution variable: Optimizeconcurrency

Table 6-5 Data Load

Label Existing Variable in Use Default Value Description

Enable Consolidation Member

DSO and non-DSO

Disabled

Allows clearing of Consolidation member data during Data Load.

This setting is migrated from the corresponding substitution variable: Dataloadconsolmember

Roll-Forward account / CTA Reversal

DSO and non-DSO

Disabled

Prevents reversal of Roll Forward and CTA accounts for a Closing Balance Input (CBI) data load.

By default, when a CBI data load is executed, the prior period Closing Balance of all accounts is reversed and the loaded data is entered as a Year-To-Date (YTD) value. When this setting is enabled, the system Roll-Forward and CTA accounts (which cannot be loaded) are not reversed.

Roll Forward accounts

  • FCCS_Retained Earnings

  • FCCS_REC_OBFXCTA

  • FCCS_OCI_OBFXCICTA

CTA accounts:

  • FCCS_CTA
  • FCCS_CICTA
  • Application-specific CTA account

This setting is migrated from the corresponding substitution variable: Donotreverserfaccountsforcbiload

YTD Reversal - Closing Balance Input

DSO and non-DSO

Disabled

If this setting is enabled, the Closing Balance YTD load can be enabled.

This setting is migrated from the corresponding substitution variable: NewLoadYTDClosingBalanceInput

Table 6-6 Other Settings

Label Existing Variable in Use Default Value Description

Disable Seeded Security

DSO and non-DSO

Disabled

Disable the default seeding of security groups.

This setting is migrated from the corresponding substitution variable: Disableseededsecurity

Enable Excel Number Format

DSO and non-DSO

Disabled

Export report numeric data to Excel as numbers instead of cell text.

This setting is migrated from the corresponding substitution variable: Enableexcelnumberformat

Journal Precision

DSO and non-DSO

10

Number of Decimal places to be used for Journals Debit/Credit

Table 6-7 Legacy

       

Optimize Data Clear

 DSO and non-DSO Enabled

Improves the data load pre-process Replace mode performance