Consolidation Options

Consolidation is the process of gathering data from dependent entities and aggregating the data to parent entities. Launching consolidation runs the consolidation process for the specified scenario, year, period, entity, and value. As a part of that process, consolidation for all descendant entities and all prior time periods within the same year is run, if it has not been run previously. The consolidation process runs all calculation rules functions for each affected entity and value, and the translation process runs as necessary to convert from child entities to parent entities. The consolidation process does not run translation rules for currencies that are not used in the process of deriving parent entity data from its children.

These options are available for consolidating data: Consolidate (Impacted), Consolidate All with Data, and Consolidate All.

Consolidate (Impacted Consolidation)

The Consolidate (Impacted Consolidation) option is available for any parent entity with a calculation status of CN or CN ND. When you select this option for a parent entity, the system performs calculations (Calculate, Translate, Consolidate) for any dependent entity within the consolidation path of the selected parent that has a calculation status of CN, CN ND, CH, TR, or TR ND, on the current period or on any prior period in the current year. Consolidate is the most efficient option because only entities that require consolidation are updated.

Process units with a status of NODATA on the current period and all prior periods are skipped.

Process units with a status of OK or OK SC on the current period are not recalculated, retranslated, or reconsolidated.

If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period.

Consolidate All with Data

The Consolidate All with Data option is available for any parent entity, regardless of its status. When you select this option for a parent entity, the system consolidates every dependent entity within the consolidation path of the selected parent that contains data, regardless of its status, in the current period or in any of the prior periods. This option is useful for updating system status from OK SC to OK after metadata changes.

Process units with a status of NODATA on the current period and all prior periods are skipped.

Process units with a status of OK or OK SC on the current period are recalculated, retranslated, and reconsolidated.

If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period.

Consolidate All

The Consolidate All option is available for any parent entity, regardless of its status. When you select this option for a parent entity, the system performs calculations for every process unit within the consolidation path of the selected parent, regardless of its status. It consolidates all entities whether they contain data or not. This option is useful when an update from prior periods is required, or when an entity with no data needs to be populated using allocations. This option should be used sparingly because the system does not omit entities with no data, which can have a significant impact on consolidation performance.

Process units with a status of NODATA on the current period are calculated, translated, and consolidated.

Process units with a status of OK or OK SC on the current period are recalculated, translated, and reconsolidated.

If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period.