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 DSO and non-DSO |
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 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 Dim consolidation |
Parallelcustomdimdso DSO only |
Disabled | Optimize Custom dimension calculations. |
Optimize Custom dimension calculations. Limitations: DSO applications |
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:
|
Optimize Custom Dim 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. |
By default, FX variances are calculated on a Periodic basis. FX variances are calculated on a YTD basis when this setting is enabled |
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. |
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:
CTA accounts:
|
Enable Closing Balance YTD Load |
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. |