Data Model Synchronizer 

Use

When you make changes to your data model in the Business Information Warehouse (BW) (for example, you change the length of a field or a data type), these changes are not automatically transferred to the data model in the Consolidation component. Instead, you need to regenerate the data elements, data structures, and tables affected by the change in the Consolidation component. The data model synchronizer helps you regenerate the data model in Consolidation.

When you launch the consolidation workbench, the system checks whether the data model in Consolidation still agrees with the data model in BW. If these two data models differ, the system automatically runs the data model synchronizer. The synchronization monitor gives you an overview of the changes to the master data in BW and the changes to objects in the data model of Consolidation. You can simulate a regeneration of the objects and then perform a real regeneration. Only after both data models agree with each other are you able to proceed with your work in the consolidation workbench.

Regeneration of data elements, data structures, and tables can lead to loss of data. Therefore, always check the results of a regeneration using the simulation before performing an actual regeneration.

This is especially true if you shorten the length of a field required for the Consolidation system and you have posted data in the meantime. In such a case, loss of data is almost inevitable.

Furthermore, data certainly will be lost if you remove characteristics in Customizing for Consolidation that are referenced by other characteristics. Under no circumstances can such encroachments be reversed by the data model synchronizer.

Prerequisites

To execute the data model synchronizer, you require authorization for authorization object FB_SRV_DMS.

Features

You can regenerate the tables for your current data basis or for your current client. Regenerating tables for the current client also may affect other application components.

The following functions are available in the synchronization monitor:

·       Display of Changes in BW

The area under Master Data lists the objects of the selected data basis that have changed in BW. The area under Changes lists what has changed in the master data of the object (for example, the new length of a field).

The traffic light indicates whether the change necessitates the regeneration of the affected objects. You also can display the error messages of the changes. To do this, choose Display Messages.

·       Display of Affected Objects in Consolidation

The objects affected by the changes are listed in the following places:

¡      Master Data lists the changed objects for the selected data basis. Generated Objects lists all data elements, data structures, and tables affected by the change.

¡      Consolidation Area shows any objects of a consolidation area that have been affected by the change.

¡      Cross Tables shows any client-independent tables that have been affected by the change.

·       Simulation of a Regeneration

You can simulate a regeneration of the affected tables. The following options are available:

¡      You can simulate a regeneration for each affected object. To do this, choose Preview of Table Conversion for the object. The system displays an overview of the table, before and after the regeneration.

¡      You can run the simulation in a single series for all affected objects of the data basis, the consolidation area, and the affected cross-client tables. To do this, choose Check.

The simulation displays messages in the lower area of the screen. The traffic lights indicate whether the regeneration of each object was successful.

·       Execution of a Regeneration

To execute a regeneration of the affected objects, choose Generate Everything. A regeneration can be run only for all objects in a single run.

The regeneration displays messages for the individual objects in the lower area of the screen. The traffic lights indicate whether the regeneration of each object was successful.

Activities

Perform the following steps to synchronize your data models:

      1.      Check if the changes in BW are correct and whether you really want these changes implemented in the Consolidation system.

      2.      Simulate the regeneration of the affected tables and examine the results.

      3.      Execute the regeneration of the affected tables and examine the results.

Der

...