Substitution Variables Available for Migration to Consolidation Settings

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

Financial Consolidation and Close 24.04 Substitution Variables Available for Migration

In the Financial Consolidation and Close 24.04 update, these substitution variables are available for migration to Consolidation Settings:

Table 6-4 Consolidation

Label Existing Variable in Use Default Value Description Detailed Description
Enable Simple Aggregation Enablesimpleaggregation

Non-DSO only

Enabled Optimizes the aggregation operations during the consolidation process. If this setting is enabled, it optimizes the aggregation operations during the consolidation process.
Optimize YTD Optimizeytdcalculation

Non-DSO only

Enabled Optimize the YTD Calculation performance. If this setting is enabled, it optimizes the YTD Calculation performance during the consolidation process.
Optimize Concurrency

Optimizeconcurrency

Non-DSO only

Disabled

Take advantage of higher concurrency during consolidations.

If this setting is enabled, the Opening Balance Carry Forward calculation is performed on all levels.
Optimize Custom Dimension Consolidation

Parallelcustomdimdso

DSO only

Disabled Optimize Custom dimension calculations.

Optimize Custom dimension calculations.

Enable Yearly Consolidation

Enableyearlyconsol

DSO only

Disabled Enable to improve performance for multi-period consolidations.

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.

Optimize Custom Dimension Translation

Parallelcustomdimtranslation

DSO only

Disabled Optimize Custom dimension calculations in the default translation . Optimize Custom dimension calculations in the default translation.
YTD FX Calculation

YTDFXCalculation

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.

YTD FX Revised

YTDFXRevised

Applicable only for multi-currency applications.

DSO and non-DSO

Disabled Calculate Foreign Exchange (FX) values on a Year-to-Date (YTD) basis for Historical accounts.

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

Optimize Consolidation Job

OptimizeConsolidationJob

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

Auto Recompute

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

Table 6-5 Data Load

Label Existing Variable in Use Default Value Description Detailed Description
Enable Consolidation Member

Dataloadconsolmember

DSO and non-DSO

Disabled Clear only loaded level 0 consolidation members. Clear only loaded level 0 consolidation members.
Roll-Forward account / CTA Reversal

Donotreverserfaccountsforcbiload

DSO and non-DSO

Disabled Do not reverse Roll-Forward and CTA accounts for a Closing Balance Input CBI) data load.

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
YTD Reversal - Closing Balance Input

NewLoadYTDClosingBalanceInput

DSO and non-DSO

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

Table 6-6 Other Variables

Label Existing Variable in Use Default Value Description Detailed Description
Disable Seeded Security

Disableseededsecurity

DSO and non-DSO

Disabled Disable the default seeding of security groups. Disable the default seeding of security groups.
Enable Excel Number Format

Enableexcelnumberformat

DSO and non-DSO

Disabled Export report numeric data to Excel as numbers instead of cell text. When exporting reports to Excel, the numeric values are exported by default as cell text. Enable this setting to export numeric report values to Excel as numbers instead of cell text.