1. Administering Financial Consolidation and Close
  2. Working with Rules
  3. Working with Configurable Calculations
  4. Configurable Calculation Rules

Configurable Calculation Rules

You manage configurable calculation rules from the Consolidation Process page.

Sample Consolidation Process page

Multi-Currency Applications

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.

Calculation Rows

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 rule icon— System. Represents that this calculation is done by Financial Consolidation and Close.
  • Human icon— 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.

Example:

  1. From the Local Currency tab, click on either After Opening Balance Carry Forward or Final Calculations.

    The system opens Calculation Manager.

  2. 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

    • FCCS_20_Final Calculations_LocalCurrency

  3. 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 19-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.

Note: 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. CONFCALC_ENABLE_RATE_AMOUNT_OVERRIDE = True

See Creating and Assigning Values to Substitution Variables.

   
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 Final Calculations FCCS_40_Final_Calculations

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 Final Calculations FCCS_60_Final_Calculations

Consolidated insertion rules are restricted to: Parent Currency / Elimination.

    

Table 19-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
Consolidated Final Calculations FCCS_140_Final_Calculations

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 create the following Substitution Variables and set the values to True:

  • CONFCALC_FCCS10_DISABLECALCDIM
  • CONFCALC_FCCS20_DISABLECALCDIM
  • CONFCALC_FCCS25_DISABLECALCDIM
  • CONFCALC_FCCS30_DISABLECALCDIM
  • CONFCALC_FCCS40_DISABLECALCDIM
  • CONFCALC_FCCS50_DISABLECALCDIM
  • CONFCALC_FCCS60_DISABLECALCDIM
  • CONFCALC_FCCS70_DISABLECALCDIM

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 create a Substitution Variable named CONFCALC_FCCS20_DISABLECALCDIM and set the value to True.

If you want the system to not generate CALC DIM logic for a single-currency application, you should create the following Substitution Variables and set the values to True:

  • CONFCALC_FCCS110_DISABLECALCDIM
  • CONFCALC_FCCS120_DISABLECALCDIM
  • CONFCALC_FCCS130_DISABLECALCDIM
  • CONFCALC_FCCS140_DISABLECALCDIM
  • CONFCALC_FCCS150_DISABLECALCDIM

Be aware that since disabling CALC DIM logic affects the consolidation script generation, you should carefully check your consolidation results.