Delta Update

[Former Member]

Hello All,

We are using BW 3.5. We have created one transcational cube and data for the same is loaded from BPS layout. Typically data is for month with Plant and planned amount for the plant.

Now user wants to update the data already entered. How to handle delta update in cube when data is loaded from BPS?

Thanks in advance

Regards: Gaurave

[Former Member · Accepted solution]

It is always delta enabled when you save data through planning area unless you have nopt made the request enabled for reporting.

e.g.

for plant P1 amt 100 & you saved the data & afterwards you felt to change it to 20 & you entered plant P1 amt 20 in planning folder & saved it again then the underlying records in transactional cube will be as follows ---

Plant Amt

P1 100

P1 -80

[Former Member · Accepted solution]

But we not getting this record.

Plant Amt

P1 100

P2 100

Now when user updates, he enters

Plant Amt

P1 100 (without changing)

P2 110

now report will show for P1 = 0

how to handle this?

[Former Member · Accepted solution]

In above case records in the cube will be as follows ---

Plant Amt

P1 100 (Original)

P2 100 (Original)

P1 0 (Updated)

P2 10 (Updated)

At report level

P1 100

P2 10

<b>But this will happen only when the original request is still running.i.e. it is yellow & not available for reporting.</b>

[Former Member · Accepted solution]

I checked. Delta part is working correctly when user enters data directly using BPS0 t-code. but web interface developed is giving problem.

Any help you can give to check web interface for BPS?