Start of Content Area

 Function documentation System Response to Changes to Master Data and Hierarchies   Locate the document in its SAP Library structure

Use

If the hierarchies and attributes of characteristics that belong to an InfoCube have been changed, you have to make structural changes to the aggregates to modify the data accordingly.

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 may take some time.

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 certain threshold value, modifying the aggregate is more time consuming than reconstructing it. You can change this threshold value. In the Implementation Guide (IMG), choose SAP NetWeaver Business Intelligence Performance Settings Parameters for Aggregates 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). 0 means that the aggregate is always reconstructed. Keep changing these parameters 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 posted negatively and the new data records are posted 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 Modification

...

       1.      In the Data Warehousing Workbench menu, select Tools Hierarchy/Attribute Changes. (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 Modification

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 the 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 This graphic is explained in the accompanying text Log 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 will find a status display for all change runs executed in the BI system. In the navigation window, choose Monitors Change Run. The Monitor for the Change Run screen appears.

Choose This graphic is explained in the accompanying text Change Run. A dialog box for selecting a run ID appears.

When you choose This graphic is explained in the accompanying text Logs, a dialog box for selecting a process type appears. Choose Change Run. The screen for displaying the relevant log in the application log appears.

 

End of Content Area