Show TOC

System Response to Changes to Master Data and HierarchiesLocate this document in the navigation structure

Use

If hierarchies and attributes of InfoCube characteristics have changed, structural changes need to be made in the aggregates in order to adapt the data.

Caution

Note that with a structural change, all aggregates of all InfoCubes are modified if they are affected by the changes to the hierarchies and InfoObjects. This can be time consuming.

You can still report on the 'old' hierarchies and attributes during the change run.

Integration

If the changes affect an amount of data that exceeds a reasonable limit, modifying the aggregate is more time consuming than reconstructing it. You can change this threshold value. In the Implementation Guide (IMG), choose Start of the navigation path SAP NetWeaver Next navigation step Business Intelligence Next navigation step Performance Settings Next navigation step Parameters for Aggregates End of the navigation path in the section Percentage Change in the Delta Process. In the Limit with Delta field, enter the required percentage (a number between 0 and 99). Zero means that the aggregate is always reconstructed. Change these parameters as many times as necessary until the system response is as quick as possible.

Features

If an aggregate is affected by changes to the data, it is either modified (in a delta process) or reconstructed. When you modify an aggregate, the obsolete data records are read negatively whereas the new data records are read positively.

You can modify aggregates manually or automatically using a program.

You can start multiple change runs simultaneously. The prerequisite for this is that the lists of master data and hierarchies to be activated are different and that the changes affect different InfoCubes. If a change run terminates, you have to start the same change run again. You do this by starting the change run again with the same parameters (same list of characteristics and hierarchies).

Activities

Manual Modifications

  1. In the Data Warehousing Workbench menu, select Start of the navigation path Tools Next navigation step Hierarchy/Attribute Changes End of the navigation path. (Alternatively, in the Data Warehousing Workbench, in the Administration functional area, choose Change Run). The Execute Hierarchy/Attribute Changes for Reporting screen appears. On this screen, all the executed change runs are listed with detailed information. Even if the application logs for change runs have been deleted, the change runs will still be displayed in the history. All the InfoObjects and hierarchies that are scheduled for the structural change are selected by default.

  2. If you only want to carry out the structural changes for individual InfoObjects and hierarchies, select the InfoObject List or Hierarchy List pushbutton. Remove from the list the InfoObjects and hierarchies that you do not want to change.

  3. Schedule a new structural change by choosing Selection and specifying the start date. The status of the structural change is displayed in the upper section of the screen.

Automatic Modifications

To schedule the same function when Executing a Report Directly, enter the program name RSDDS_AGGREGATES_MAINTAIN.

You can also include the program in a process chain and schedule it regularly in background processing.

Example

The attributes for characteristic 0MATERIAL are uploaded weekly. You can schedule the program so that it starts after the upload. You can also use InfoObject List 0MATERIAL as a variant so that only changes that are made to the material attributes are taken into account. Other changes, which may only be needed later, are ignored.

Choose the Log pushbutton to display the messages for the hierarchies and attributes that have been changed manually, or automatically.

Status Overview of Change Run

In the Administration functional area of the Data Warehousing Workbench, you find a status display for all executed change runs in the BW system. In the navigation pane, choose Start of the navigation path Monitors Next navigation step Change Run End of the navigation path. The Monitor for the Change Run screen appears.

Choose Change Run. A dialog box for selecting a run ID appears.

By choosing Logs, a dialog box for selecting a process type appears. Choose Change Run. The screen for the display of the relevant log in the application log appears.