Skip to Content
0
Former Member
Aug 02, 2008 at 04:43 PM

Init+delta in BW, subsequent delta in BI - upgrade issue

13 Views

We are upgrading to BI patch 16 from BW 3.5.

Our BW dataload flows are - R/3 extractor to ODS via infopackages (PSA and then data target option), then to the infocubes via infopackages (same option).

In BI, data come to PSA via infopackages, then to DSO via DTP. From DSO data go to the infocube using DTP (no PSA). For DTP we use 'Get data by Request' option and extraction mode is delta.

We already have deta loaded in the system in BW. Daily process chains load delta records. We would like to continue the process by doing just the delta load in BI (without deleting old records and doing a new init in BI).

What happened is, delta load to DSO went fine after the upgrade. However, when loading to the cube DTP started to bring back all old data to the cube (past init and delta records) duplicating data in the cube. After first run subsequent run to the cube goes fine, bringing just the delta records.

What set up are we missing for the infocube so that we can continue with delta loads in BI after upgrade from BW?