Skip to Content
0
Former Member
Nov 09, 2012 at 04:55 PM

Missing records in the infocube in delta update from DSO in BW 7.3

284 Views

I am having a production issue and any input is greatly appreciated.

Some of the delta records are not getting updated in the data targets (infocube and DSO) when loading from a DSO using a delta DTP.

We are on BW 7.3 and recently applied the OSS Notes 1629258 and 1629890 to fix the missing records. I do not find any missing records if I run the report-RSBK_GET_TRUNC_REQS_PROCMODEA.

Details: Datasource:2LIS_11_VASCL.

We are having issues with the Value (price) and not with the quantity. Quantity has been updating correctly and there is no calculation involved.

The price is calculated in our transformation from DSO to cube of the 2LIS_11_VASCL (schedule line level) data source We do a look up in the DSO(2LIS_11_VAITM - item level) and get the net price and quantity from there and do the calculation. The delta's are getting extracted correctly and is loaded to the DSO's. The update from the DSO using delta DTP is not correct all the time.

If we delete the cube and do a full load from the active table of DSO, the data gets picked up and loads correctly to the cube. But as we get the new deltas, we can see the inconsistency.

I have checked the filters on the DTP and the analyzed the change log tables. One thing that stood out from change log is that most of the time the missing records are reversals (0recordmode =R) and the record that is in the cube does not get cancelled. There are some records that do not fit into this criterion, but are still not getting updated correctly in the cube.

I have started looking at some OSS notes, but have not found any so far with my issue. Any pointers or guidance to resolve the issue will be of great help.

Thanks