How To Initialize Delta DTP in BW 7.x

Loading in BW 7.x is greatly simplified with the introduction of the Data Transfer Package (DTP). Initializations and deltas between two (or more) data targets are handled automatically by the system.

Where you will run into trouble with the 7.x DTP objects is during initial or reloads of a data target.

Executing a single DTP may not be an option given your particular Service Level Agreements (SLA) or project expectations. Also, declaring multiple delta DTP objects (via filter selections) is cumbersome when it’s a one-time need.

Here’s an alternative option to the 7.x DTP, based on the 3.x data model.

Similar to 3.x infopackages, you can declare an initialization package via the Execute tab/Processing Mode drop-down and choosing “No Data Transfer, Delta Status in Source: Fetched” option.

Executing the DTP with “No Data Transfer” will set the delta marker between your source and target. Afterwards, you can freely load via multiple full load DTP packages as your reload/init requires as existing data in the source will be ignored. New data in that arrives into the source (after initializing the delta) will be identified by your delta DTP.

Just remember to change the Process Mode back to “Serial Extraction, Immediate Parallel Processing” to get the deltas.

Related posts:

1. How To Group Records in a Data Package (DTP) in SAP Netweaver BW (BI)
2. How To: Resolve Data Load Issues with Dead Locks
3. SAP BW: Line Item Dimension Error