Tab Page: Updating

On the Update Parameters tab page, specify the update mode, the type of update in the data targets, error handling when loading and updating the data further, and time selection for time-dependent data.

Update Mode

You can choose from the following functions in the Scheduler:

Full update

A full update requests all data that corresponds to the selection criteria you determined in the scheduler.

Using the Scheduler menu, you can indicate a request with full-update mode as Repair Full Request. This request can be updated into every data target, even if the data target already contains data from an initialization run or delta for this DataSource/source system combination, and has overlapping selection criteria.

For information about selectively deleting from a DataStore object, seeDataStore Object Content.

Delta update

A delta update only requests data which has appeared since the last delta.

If a delta fails (status 'red' in the monitor) or the overall status of the delta request has been set to red manually, the next data request will be performed in repeat mode. A repeat request extracts the incorrect or incompletely loaded data from the failed delta request, along with any new data since the original request. A repeat can only be requested in the dialog. If data from the failed delta request has already been updated to the data targets, delete the data from the data targets affected. If you cannot delete the data from the data targets, duplicate data records may be produced when the repeat request is performed.

Initializing the delta process

To request deltas, you need to have initialized the delta process.

For selection criteria that do not overlap, several initialization criteria are possible for initializing the delta process when scheduling InfoPackages for data from an SAP system. This gives you the option of loading the relevant data for the delta process, step by step into the Business Information Warehouse. For example, you can load the data into BW for cost center 1000 in the first step, and the data for cost center 2000 in the second.

A delta requested after several initializations contains the super set of all the successful initial selections as a selection condition. This selection condition cannot be changed any more for the delta after this. In this example, data is loaded into BW for cost centers 1000 and 2000 with a delta.

The selections for initialization are made in the scheduler on the Select Data tab page.

You can display all initializations for a DataSource in the scheduler by choosing Scheduler → Initialization Selection for Source System. You can see whether an initialization selection has been executed and what the status of the initialization request is. From this dialog box, you can also transfer initialization selections into the scheduler, and delete selected initializations again. Choosing the pushbutton Initialization Request Status brings you to the monitor, where you can check the data request.

For test purposes, you can initialize the delta process without transferring data. In the Update Parameters tab page, select the corresponding indicator. When the initialization simulation runs, BW and the source system create the help entries in all required tables, but do not load data. Afterwards, the monitor displays a loaded record. The init simulation request appears in all data targets into which data was updated, but only contains the help entries.

Converting Initialization InfoPackages on Delta InfoPackages

This function allows you to use an InfoPackage in one process chain for initialize the delta process and to perform the delta transfer. Conversion to the delta transfer is performed automatically after initialization. More information:Including InfoPackages for Delta Processes in Process Chains.

Early Delta Initialization

With early delta initialization, you have the option of writing the data into the delta queue or into the delta tables for the application during the initialization request in the source system. This means that you are able to execute the initialization of the delta process (the init request), without having to stop the updating of data in the source system. You can only execute an early delta initialization if the DataSource extractor called in the source system with this data request supports this.

Build Initial Non-Cumulative

This update method is only available when you want to load data into a data target that contains a non-cumulative key figure.

Choose this update mode when loading non-cumulative data into BW for the first time. More information:Transferring Non-Cumulative Data into the BW System.

Error Handling

Error handling options allow you to define the system behavior for the following processing steps:

• Transfer rules
• Update rules
• Master data, text, and hierarchy updates
• InfoCube updates
• Referential integrity of an InfoObject against master data tables or DataStore objects on the communication structure level.

Time Selection For Time-Dependent Data

Selections for the data that is to be requested with an InfoPackage is specified in the scheduler on the Data Selection tab page. The time selections for time-dependent data are specified on the Update tab page. The DATETO and DATEFROM fields, as well as the fields that are assigned to the 0DATETO and 0DATEFROM InfoObjects, are therefore not available as selection fields on the Data Selection tab page.

Various options are available for selecting time-dependent data that you want to load into the BW:

• Fixed time interval
• Creating a routine

  You use this routine to specify complex time selections for the data that you want to request. For example, when you only want to load the data for specific times that cannot be determined by an interval or a variable.

• Using variables (seeVariables)

  Variables are placeholders for values and are replaced with concrete values when data is requested. For example, you use the variable 0CMONTH to load the data for the current calendar month.

  Note

The way that selections are filled at runtime depends on theprocessing type for the variable. For time selections, you cannot use any variables that use a replacement path or require manual input.

The system does not check for data type and length when selecting variables. If errors occur, they are not found until the runtime of the data request. However, you can display the selections for a particular variable by choosing Check. The system displays the restrictions that would apply when data is requested in a table. If the variable cannot be used to determine the selection conditions, an error is produced and the display is terminated.

You should only create variables (inBEx Query Designer) for time selection if you want to use the resulting selection condition in several InfoPackages.Use a routine for time selection if a simple interval or existing variables are not sufficient.