Consolidation Monitor

The Consolidation Monitor is a global dashboard for monitoring the consolidation progress for a specific consolidation scope, which is made up of a category, period, group, or sub-group.

The Consolidation Monitor is a key component in executing incremental consolidations, since it communicates to the consolidation engine on which entities to execute a currency translation or consolidation. For more information about setting up your consolidation environment with dimension properties, model settings, and journal definitions, see Consolidation.

The Consolidation Monitor displays the Group/Entity hierarchy created in the Ownership Manager (only Consolidation type models). For information on configuring an ownership-based hierarchy, see Ownership Manager.

The scope context area displays the selected dimension members: Time, Category and Group.

You can perform a full consolidation, which processes all entities in the ownership-based hierarchy, or you can perform an incremental consolidation, which processes only updated entities. Incremental consolidations reduce the impact on system performance and decrease response time.

Incremental consolidations and currency translations

You perform incremental currency translation or consolidation, or both, in the following cases:

When an update to an entity is more recent than the last currency translation performed for the group or sub-groups to which the entity belongs, then an incremental currency translation must be performed for the entity.
When an update to an entity is more recent than the last consolidation performed for the group or sub-groups to which the entity belongs, then an incremental consolidation must be performed for the entity.
When currency translation is performed for an entity, then an incremental consolidation must also be performed, regardless of when the last consolidation was run.

Example

A currency translation and a consolidation are performed on the Groups G_WORLD and G_ASIA, at 9:00 a.m. and 9:01 a.m., respectively:

Category	Time	Groups	Currency translation	Consolidation
Actual	2009.DEC	G_WORLD	2010/09/01 09:00 a.m.	2010/09/01 09:01 a.m.
Actual	2009.DEC	G_ASIA	2010/09/01 09:00 a.m.	2010/09/01 09:01 a.m.

At 9:05 a.m., the data for the entity Shanghai is updated:

Category	Time	Entity	Data Updated
Actual	2009.DEC	Shanghai	2010/09/01 09:05 a.m.

Since the data update occurs after the last currency translation and consolidation on the Groups to which the entity Shanghai belongs, an incremental currency translation and consolidation must now be performed on the entity Shanghai.

Technical entity storing aggregated data

If the Groups dimension (G or R type) contains group members (currency_type= G) having a corresponding consolidation entity ( STORE_GROUP_CURR=Y and ENTITY=<Entity Dimension Member>) then, not only the base entity with new data is reconsolidated, but at the end of each step (currency translation and consolidation processes), the consolidation entity also re-aggregates all of the data of the entity members.

In the example above, when a currency translation and consolidation are performed for the entity Shanghai, the corresponding consolidation entities ( E_WORLD and E_ASIA) re-aggregate data from all owned entities for the corresponding groups (if G_ASIA has three entities: Shanghai, Seoul and Tokyo, all three entities are re-aggregated to E_ASIA. The same principle applies to G_WORLD).

Prerequisites

An administrator has given you the View Consolidation Monitor and Run Consolidation Tasks access rights.

Features

In the Consolidation Monitor you can do the following:

Display the control set status

Display the results of control execution. The control set status enables users to verify the accuracy of reported data. For more information, see Control Set Status.
Display the work status

Show the level of completeness of submitted data.

To display the work status in the Consolidation Monitor, the driving dimensions must be at a minimum Category, Period and Entity. If additional dimensions are added, then a member must be selected for each additional dimension to enable work statuses to be displayed. Every time a work status is changed, the appropriate control set status must be checked.
Display the currency translation status

Display the outcome of the currency translation processing. The status can be "Done" or "To be executed" if data was modified since the last consolidation was executed.
Run currency translations

Available currencies are those specified in the Group dimension or group members. Currency translation is available at the entity level. When you select a base entity and run the currency translation for this entity, you can select the reporting currency in which to run the translation. When you select a Group or Sub-Group, the currency translation is run on the currencies defined for the selected group. For more information, see Run a Currency Translation.
Display the consolidation status

Display the outcome of the consolidation processing. The status can be "Done" or "To be executed" if data was modified since the last consolidation was executed.
Run consolidations

Generate consolidated data using data entered in packages manually or uploaded using Data Manager, and journal entries (Journals). For more information, see Run a Consolidation.
Display the running processes

Running processes are displayed with percent completion. You can only display processes for Groups to which you have Read access.
Reset the consolidation status

You can reset the status of a consolidation to "To be executed", in which case you would then need to run a full consolidation. For example, you may want to reset the consolidation status to "To be executed" in the following cases:
- Changes in the Rate and Ownership InfoProviders do not trigger incremental processes (consolidation and currency translation)
- Incremental processes for simulation categories do not verify updates to source categories
- Masterdata changes do not trigger incremental processes

Activities

Set the work status for an entity
1. In Consolidation Consolidation Monitor, select an entity and click Work Status in the toolbar.
2. In the Change Work Status dialog box, verify the selections in the Change Status For groupbox.
3. Choose a new status in the New Work Status groupbox and click OK.
Run a currency translation.
Run a consolidation and display running processes.