You manage configurable calculation rules from the Consolidation Process page.
If you have a multi-currency application, the Consolidation Process page displays three tabs: Local Currency, Translated, and Consolidated.
The tabs depict the consolidation flow that Financial Consolidation and Close follows. It first performs calculations for base-level members in their local currency, then performs the translation to parent currency, and finally performs the consolidation.
Single Currency Applications
If you have a single currency application, the Consolidation Process page displays two tabs: Local Currency and Consolidated.
Each of the tabs on the Consolidation Process page displays multiple rows that depict in order, the flow of calculations that are performed. Each row is marked by one of these icons:
- — System. Represents that this calculation is done by Financial Consolidation and Close.
- — Insertion point for user-defined rule. Represents the point in the process where you can insert your calculations from Calculation Manager.
When you select any of the rules in the list, the system displays a Properties panel on the right with information such as the rule name, the consolidation members for which the rule would be processed, and any override specifications, if applicable.
When you click on a row where you can insert a user-defined calculation, Calculation Manager opens in a separate tab in the browser.
From the Local Currency tab, click on either After Opening Balance Carry Forward or Final Calculations.
The system opens Calculation Manager.
Expand the "Planning" folder on the left side until you see the FCCS Consol seeded rules in Calculation Manager, for example:
FCCS_10_After Opening Balance Carry Forward_LocalCurrency
The Calculation Manager rules correspond to the Configurable Calculation rows. For example:
The Calculation Manager rule: FCCS_10_After Opening Balance Carry Forward_LocalCurrency
corresponds to the: After Opening Balance Carry Forward row, where you can add your own calculations. These are calculations to be performed after the Opening Balance Carry Forward calculations, but before balancing the Balance Sheet.
The Calculation Manager rule: FCCS_20_Final Calculations_LocalCurrency
corresponds to the Final Calculations row, where you can add your own additional calculations to be performed after the Balance Sheet is balanced.
The following table lists the Financial Consolidation and Close rows for each tab and the corresponding Calculation Manager rules.
Summary of Configurable Calculation Rules
Table 18-3 Multi-Currency Calculations
|FCCS Tab||FCCS Row||Rule in Calculation Manager|
|Local Currency||After Balance Carry Forward||FCCS_10_After Opening Balance Carry Forward|
|Local Currency||Final Calculations||FCCS_20_Final_Calculations|
Local Currency insertion rules are restricted to: Entity Currency / Entity Input / Entity Elimination Adj / Entity Consolidation.
In addition to Entity Input for the Consolidation dimension, you can also specify FCCS_Amount Override or FCCS_Rate Override as a valid Consolidation member.
If you want to use FCCS_Amount Override or FCCS_Rate Override, you must first set the following substitution variable for the Consol cube to enable it.
|Translated||Before Foreign Exchange (FX) Calculations||FCCS_25_Before FX_Calcs|
|Translated||After Opening Balance Carry Forward||FCCS_30_After Opening Balance Carry Forward|
Translated insertion rules are restricted to: Parent Currency / Entity Input / Entity Elimination Adj / Entity Consolidation
|Consolidated||After Opening Balance Carry Forward||FCCS_50_After Opening Balance Carry Forward|
Consolidated insertion rules are restricted to: Parent Currency / Elimination.
Table 18-4 Single Currency Calculations
|FCCS Tab||FCCS Row||Rule in Calculation Manager|
|Local Currency||After Balance Carry Forward||FCCS_110_After Opening Balance Carry Forward|
|Local Currency||Final Calculations||FCCS_120_Final_Calculations|
|Consolidated||After Balance Carry Forward||FCCS_130_After Opening Balance Carry Forward|
Disabling CALC DIM Logic
When you create configurable calculation scripts for an insertion point, Financial Consolidation and Close automatically generates data at parent levels so that these parent members are available in the next insertion point. The system adds CALC DIM logic to roll up the data that you populate. Processing this added CALC DIM logic is a time-consuming process depending upon the complexity of your hierarchy. If you do not need to refer to recalculated parent members in later insertion points, you may speed up the overall consolidation process by disabling the CALC DIM logic that the system adds for insertion points.
If you want the system to not generate CALC DIM logic for multi-currency applications, you should define the following Substitution Variables and set them to True:
For example, if you have written custom logic in the FCCS_10 and FCCS_20 configurable calculation rules. If you want to disable CALC DIM logic for FCCS_20, but not for FCCS_10, you should define a Substitution Variable named CONFCALC_FCCS20_DISABLECALCDIM and set it to True.
If you want the system to not generate CALC DIM logic for a single-currency application, you should define the following Substitution Variables and set the to True:
Be aware that since disabling CALC DIM logic affects the consolidation script generation, you should carefully check your consolidation results.