Consolidation
Consolidation is the process of taking base level Entities and aggregating them up a hierarchy to their Parent. The hierarchy and add efficiencies where applicable, meaning some siblings may be able to run in parallel when they are processed. Calculations and translations are also run during this process.
Consolidations can be launched from the Process step in Workflow, Cube Views or Forms. By triggering a consolidation, the existing POV is run for that time period and is consolidated for the respective period along with any of the prior periods for that year. For example, if a consolidation is triggered for June, it will consolidate January through June.
The following chart explains how the Consolidation Dimension works.
| TOP - Contributes to the Parent Entity’s LOCAL Member | |
|
Sum (SHARE + ELIMINATION + OWNERPOSTADJ)
|
|
|
OWNERPOSTADJ (Execute Data Unit Calculation Sequences, FinanceFunctionType = Calculate) |
|
|
|
Stores Journal entries that are needed after the Share and Elimination calculations have been performed for an Entity and Parent.
|
|
ELIMINATION (Execute DUCS, FinanceFunctionType = Calculate) |
|
|
|
|
|
Elimination algorithms (Use default or implement FinanceFunctionType.ConsolidateElimination in a BR) |
|
|
|
Start with SHARE Data Unit and eliminate data cells where IC is not None. If a common Parent Entity was reached for both the Entity and the IC Entity, generate an offset amount and a plug Account amount.
|
|
SHARE (Execute DUCS, FinanceFunctionType = Calculate, only if not using default calc-on-the-fly) |
|
|
|
Default Share is calculated on-the-fly Sum (TRANSLATED + OWNERPREADJ) * % Consolidation |
|
|
|
|
Share algorithms (Use default or stored, or implement FinanceFunctionType.ConsolidateShare in a BR) |
|
|
|
|
|
OWNERPREADJ (Execute DUCS, FinanceFunctionType = Calculate) |
|
|
|
Stores Journal entries that are needed before the Share and Elimination calculations have been performed. This is a Relationship-level Member, so the data is for a specific Parent Entity.
|
|
TRANSLATED (Execute DUCS, FinanceFunctionType = Calculate) |
|
|
|
The “Translated” Member is a shortcut to the Consolidation Member that matches the Parent Entity’s default currency (e.g., USD). It stores data that was generated by multiplying local currency data by FX rates, and then executing the DUCS.
|
|
Translation algorithms (Use default or implement FinanceFunctionType.Translate in a BR) |
|
|
|
Determine FX Rates and multiply to create a translated Data Unit from the local currency’s Data Unit.
|
|
LOCAL |
(Execute DUCS, FinanceFunctionType = Calculate) |
|
|
The “Local” Member is a shortcut to the Consolidation Member for the Entity’s default currency (e.g., EUR). It stores input data in base Entities, or data that was consolidated by combining data from the TOP consolidation Member from lower-level child Entities. |