cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BI Change log summation issue

sri_harsha2
Participant
0 Kudos

Hello Gurus,

I have come across a strange issue in at the DSO and cube level in Production. The cost, subtotal 2, Subtotal 6 are getting tripled in the Info cube. I have created some test billing documents and loaded them into the DSO and cube they match with the VBRP base table cost, Subtotal2 and subtotal6. But when changes are made to the invoices then the issue is coming in the cost and subtotals. For instance the Cost for the invoice was 2,995 and I did a full load. The data in the DSO matches with the VBRP table

Later the change was made to the cost and changed to 3,995. When I trigger the delta it looks fine till the PSA and New table of DSO

But at the DSO the issue is showing up at the change log table.. Instead of the new record being in the After image column .. the new value 3995 summing up with the existing 2,995 value in the DSO and showing up as 6,990 in the DSO and later 2,995 is negating from the 6,990 and giving the result 2,995...

Below is the change log results

The cube is picking up the new value 6,990 and adding up with the 2,995 that is already in the cube and summing up to 9.985..

This is the issue I have been facing.. the values if cost and subtotals are tripling. The transformation in the key figures are in additive mode not in over write mode. This is a standard DSO. The key figures have been in additive mode since many years.. There was no issue with this. We started coming across this issue recently from past two months.

I request you to give me your valuable suggestion for this scenario.. Thanks in advance

Accepted Solutions (0)

Answers (0)