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	Description	Detailed Description
Enable Simple Aggregation	Enablesimpleaggregation Non-Period Movement Dense Model and Hybrid only Default: 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-Period Movement Dense Model Only Default: 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-Period Movement Dense Model and Hybrid only Default: 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 Dim consolidation	Parallelcustomdimdso DSO Only Default: Disabled	Optimize Custom dimension calculations.	Optimize Custom dimension calculations. Limitations: DSO applications
Enable Yearly Consolidation	Enableyearlyconsol DSO Only Default: 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 Dim Translation	Parallelcustomdimtranslation DSO Only Default: 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. Applicable for DSO and Non-Period Movement Dense Model Default: Disabled	Calculate Foreign Exchange (FX) variances on a Year-to-Date (YTD) basis.	By default, FX variances are calculated on a Periodic basis. FX variances are calculated on a YTD basis when this setting is enabled

Table 6-5 Data Load

Label	Existing Variable in Use	Description	Detailed Description
Enable Consolidation Member	Dataloadconsolmember Default: Disabled Applicable for DSO and Non-Period Movement Dense Model	Clear only loaded level 0 consolidation members.	Clear only loaded level 0 consolidation members.
Roll-Forward account / CTA Reversal	Donotreverserfaccountsforcbiload Default: Disabled Applicable for DSO and Non-Period Movement Dense Model	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_RE FCCS_RE_OBFXCTA FCCS_OCI_OBFXCICTA CTA accounts: FCCS_CTA FCCS_CICTA Application-specific CTA account
Enable Closing Balance YTD Load	NewLoadYTDClosingBalanceInput Default: Disabled Applicable for DSO and Non-Period Movement Dense Model	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	Description	Detailed Description
Disable Seeded Security	Disableseededsecurity Default: Disabled Applicable for DSO and Non-Period Movement Dense Model	Disable the default seeding of security groups.	Disable the default seeding of security groups.
Enable Excel Number Format	Enableexcelnumberformat Default: Disabled Applicable for DSO and Non-Period Movement Dense Model	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.