Filter out records with the Same Key?

[Former Member]

Hi SDN,

I am trying to load from a write-optimized DSO to a standard DSO. Based upon the key, the source DSO have two records with the same key DOC_Num+Doc_Item. The second record has STOR_NO = 'R' and quantity reversed in sign to negative. When the load takes places (and I have debugged it) only the second record is processed and I suspect that DTP in its step 'Filter Out New Records with the Same Key' is dropping the first record.

Can someone explain the process here because I was expecting both records in the End Routine so that I would sum up both the records leading to a zero. As I have now, the lone records returns a negative quantity with no offset.

Thanks.

SM

[Former Member]

Hi,

As Oscar has said this is happened due to overwirte. You can solve this by creatinga a code as per your requirement in Start routine instead of end routine. otherwise while updateing keyfigure just use Additive mode instead of delta mode.

Regards,

[Former Member]

This happens because when you use a export datasource to an ODS the data with the same key is overwrite...its the normal behavior of an ODS if you want to maintain the structure of the ODS your destination must be an infocube............if you want the same data in both ODSs...you must create another update rule and load in one process both ODSs.....

Regards