Creating Update Rules for Data Targets (SAP Library - SAP Business Information Warehouse)

Creating Update Rules for Data Targets

Prerequisites

To be able to maintain update rules, in the Administrator Workbench, choose Modeling ® InfoProvider ® Your InfoProvider ® Context Menu (right mouse button)® Create Update Rules.

Procedure

Select a data source. Choose between an InfoSource, ODS object and InfoCube.

Choose Next Screen .

A proposal for the update rules is generated from the data target. You can use Technical Name to display the technical name used to describe the fields.

Alternatively, transfer an update rule from Business Content.

Select a field by double-clicking on it, or use the Type pushbutton.

Define the Update Type for the displayed key figure or data field.

Select an Update Method.

Also select an update method for the characteristics and time reference or for the key fields.

Note

Note: For non-cumulative cubes, only the time reference characteristic and fiscal year variant can be maintained. All other time characteristics are automatically derived from the time-reference characteristic. Therefore, the time-reference characteristic must not be left blank.

Select the next key figure by double clicking on it, or by selecting Type, and repeat steps 4 to 6.

Choose Save if you want to save the rules, without the system carrying out an update.

Choose Activate if you want the update to take place. An InfoProvider can only contain data with an active update rule.

Caution

Check the status of the update rules.

It must be set to active to enable the data records for your InfoSource to be updated. If this is not the case, activate the rules.