Consolidation Dimension

The Consolidation dimension provides an additional layer to the financial information, which enables you to view details on input values, adjustment, and contribution information. It includes entity data, such as the input value and any related adjustments to the entity’s data. As a dependent entity’s values roll up into its parent during consolidation, the system stores consolidation detail including Proportion and Elimination detail. Proportion detail contains the balances resulting from the execution of the proportionalization consolidation rule. This reflects the application of the consolidation percentage on the source data. Elimination detail contains the results of all other consolidation and elimination rules.

The Consolidation dimension includes the following members:

  • Entity Input—This member represents input data and non-consolidation -related business logic (for example, member formulas).

  • Entity Consolidation—This is only available for a Parent entity. The amount in this member represents the total of the Contribution from each of its child entities. This is a system-calculated amount as a result of the consolidation process.

  • Entity Elimination Adjustment— This is only available for a Parent entity. Entity Elimination Adjustment entries are generated by the system if the aggregated Entity Consolidation data requires adjustment. This could occur if the cumulative consolidation % of a source level 0 entity increases due to the merging of shared instances of the entity. Equity consolidations could then be required to change to Proportional or Subsidiary at an intermediate parent entity.

  • Translated Currency Input (optional) —This provides for data entry in an Input Currency.

  • Entity Total—The summation of data of an entity, including both input and adjustment data stored in the Entity Input and Translated Currency Input members, any Entity Elimination Adjustment calculated data and the total contribution stored in the Entity Consolidation member (only for a parent entity).

  • Parent Input (optional) —This provides for data entry in parent currency, and specific to an entity / parent combination. This data is included in proportionalization.

  • Parent Total (if Parent Input is enabled) —The summation of Entity Total and Parent Input.

  • Proportion—The proportionalized values of the Entity Total (or Parent Total) member of a single entity, for a specific parent entity during a consolidation of a consolidation hierarchy. There is one Entity Proportion member in the Consolidation dimension for every Parent/Child entity relationship.

  • Elimination—Consolidation adjustment and elimination data for a specific Parent/Child entity is generated and stored in this member.

  • Contribution—The consolidated result of a single entity for a specific Parent Entity. This includes the aggregation of the Proportion data and Elimination data for the Parent/Child entity.

  • Contribution Input (optional) —This provides for data entry in parent currency, and specific to an entity / parent combination. This data is entered post-proportionalization.

  • Contribution Total (if Contribution Input is enabled) —The summation of Contribution and Contribution Input.

The Consolidation dimension enables you to report on the details used to perform the different stages of the consolidation process. It stores intermediate results during the consolidation process to record how the system adjusted the consolidated members. It provides an audit trail of the transactions applied to data during the consolidation process.

The following figure shows the Consolidation dimension with Intercompany eliminations and all optional members enabled:

Consolidation Dimension

Note: * The Entity Consolidation and Entity Elimination Adjustment members are system calculated members and are only applicable to Parent entities.