Skip to Content
0
Former Member
Feb 10, 2006 at 03:17 PM

Very Strange issue

42 Views

Hello BW Experts ,

I am extracting data from standard data source 0CO_OM_OPA_1 ,which support full update only.

I have following figures on R/3 side for an order Number,

Order Number = 55667788

Cost Element = 223344 for all below cost figures

Cost Figures = 10 ,20,30,40.

And Detail for value type = 1 for all above cost figures.

Fiscal Year/period = 006.2005 same for all cost figures.

The same data is present in RSA3 for the above data source.

another example :

Order Number = 99887766

Cost Element = 665544 for all below cost figures,

Cost figures = 90,80.

And Detail for value type = 1,2 for all above cost figures.

Fiscal Year/period = 007.2005 same for all cost figures.

The same data is present in RSA3 for the above data source.

Now in BW ODS we have overwrite update type for Cost .

Due to which I am getting following data in ODS ,

<b>If the Detail for value type is same then the cost figures get overwritten in ODS as well as in infocube.</b>So in infocube i am getting only last cost figure = 40 for the Order number 55667788.

Actually there should be addition of all cost figures (102030+40 = 100).

But it does not happen if the Detail for value type is same.

In the same infocube if the Detail for value type is different , then we have addition of both the cost figures(80+90=170) as in case of Order 99887766

<b>The Detail for value type is a Not a key figure</b>,so I can not changed it to Addition update type.

I am playing with issue from last six days but could not find any solution.

I tried to make the Update type from Overwritten to Addition in case of ODS , then I get addition of all cost figures irrespective of the Detail for value type.

But this create another problem and that is I have to delete all the data daily before loading it to ODS and Infocube . We have three years data . So it become so time consuming that I have to change to Overwrite again.

ODS is used when we have to make Overwrite update type.

Now what to do in this case ?

Your valuable suggestions will be very helpful for me .

Best Regards ,

Amol Kulkarni.