Skip to Content

Data mismatch issue, wrong values in change log

Oct 19, 2017 at 06:07 AM


avatar image

Hello Gurus,

One of our client raised an issue of wrong Order Quantity for a particular Sale Order. Actual Order Qty is 10 in ECC, but BW report showing 15.There is a DSO and finally and Infocube involved in the data flow.

  • Cube output was showing as 15.
  • Active table of DSO was showing 15.
  • Change log of DSO had multiple after and before images, whose sum was showing something else.

So, I decided to do a full repair and did the following steps.

1. Deleted and filled the set up tables for this particular sale order.

2. Ran Infopackage with full repair, and delta dtp to DSO, activated dso.

3. Ran full dtp from DSO to cube with this sale order as dtp filter.

After that i checked the cube and report, which was showing as 10, but still change log was showing something different.

Couple of days later, some delta records came for this sale order, still order quantity remains as 10 in ECC, but report was showing as 20.

  • ECC value is 10.
  • BEx report showing 20.
  • Cube output is 20.
  • Active table output is 10.
  • Change log showing a big value as 55.

I believe that there was something wrong loaded to Change log earlier. Will this issue be resolved if I again do a full repair after deleting the change log entries too.

Kindly provide your valuable inputs and suggestions. Points will be assigned.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gajesh Nagesh Oct 19, 2017 at 01:09 PM


Are you using Summation or overwrite in your DSO? This will determine how your changelog will behave.



10 |10000 characters needed characters left characters exceeded