Consolidation and Translation Rules
Financial Consolidation and Close provides pre-built calculation scripts to handle consolidation and translation.
In addition, the system provides pre-built scripts and member formulas for some of the standard calculation processes.
Note:
For information on security access required for Consolidation and Translation rules, see Consolidation and Translation Security Access.
These rules are provided by default:
-
ClearEmptyBlocks
-
ComputeRates
-
Consolidate
-
Consolidate – by selected View (if Control To-Date View Storage is enabled). See Using the Control To-Date View Storage Option.
-
DataLoad_PreProcess_Consol
-
DataLoad_PostProcess_Consol
-
DataLoad_PostProcess_Rates
-
FCCSFormStatusProcessor
-
ForceConsolidate
-
ForceConsolidate - by selected View (if Control To-Date View Storage is enabled). See Using the Control To-Date View Storage Option.
-
ForceTranslate
-
ForceTranslate - by selected View (if Control To-Date View Storage is enabled). See Using the Control To-Date View Storage Option.
-
MetadataLoad_PostProcess_Consol
-
Predict Consolidation Time. See Viewing Predicted Consolidation Time.
-
RefreshDatabase_DelegatePostProcess
-
RefreshDatabase_PostProcess_Consol
-
RefreshDatabase_PostProcess_Rates
-
Translate
-
Translate - by selected View (if Control To-Date View Storage is enabled). See Using the Control To-Date View Storage Option.
-
UpdateViewCalculations. See Updating View Calculations.
You can filter the list of rules by Cube and Rule Type.
To view the list of rules:
-
On the Home page, click Rules.
-
To filter the list of rules, click the Filter icon.
-
From the Cube drop-down list, select a Cube: Consol or Rates, or use the default of All.
-
From the Rule Type drop-down list, select a type, or use the default of All:
- Scripts
- Rules
- Rulesets
- Templates
- Click Apply to apply the filter.
Optimizing Concurrency for Rules
The Consolidate and Translate business rules in Financial Consolidation and Close execute on multiple entities.
Essbase can execute business rules calculations concurrently using multi-threading.
You can add a substitution variable named OptimizeConcurrency
and
set its value to True to take advantage of higher concurrency during Consolidations.
Using the OptimizeConcurrency
variable forces Financial
Consolidation and Close calculations to make judicious use of multiple Essbase
process threads so that calculations run faster.