Question:
Hi,
I have created an ABAP program to delete ODS change log data.
This program will join data change log table with rsodsactreq table to get requests in correct order (by request timestamp).
Assume the change log data as below:
Req# KeyValue KF
R1 K1 10
R1 K2 20
R2 K1 -10
R2 K1 15
R2 K2 -20
R2 K2 10
Data will be deleted:
R1 K1 10
R1 K2 20
R2 K1 -10
R2 K2 -20
Last status of the change log data :
R2 K1 15
R2 K2 10
Considering the impact of change log to delta management, I need some comment/input/confirmation by doing this from the experts.
Is there any impact with this scenario ? Will it cause any problem in the future ? In this sample, request R1 will be gone from the change log table, is it OK ?
Appreciate for any comment.
Regards,
cy.
Answer:
What is the reason to create your own delete program for ODS log table. Do not you know that you can delete ODS log table from PSA tree->Datamart->generated DataSource 8<ODS name>. Right click on it and choose delete data PSA.
Deleting ODS log table will not impact your ability to load data again from the ODS. However you will not be able to do repeat delta of last unsuccessful load to subsequent InfoProviders (example InfoCube). It is safe to delete log table if last delta load is successful. I recommend you to schedule PSA data delete periodically (say for example every 1 or 2 month) to get rid of unused change log data.
_________________
Ali H. Alwan
Atos Origin Middle East
Saudi Arabia
Answer:
Hi Ali, thanks for the quick response.
I did know on 3.0 onward there was a function provided by SAP to delete ODS change log, some kind of PSA deletion.
I can not use the delivered function is because I can not ensure that the data will not be updated again. Our data lifetime is very long, it could be in year or years. And as we know, after the data deleted from the change log, the delta will never be supported again, meaning the data will be loaded in wrong figure....so I make my own program to delete & keep the data in the last status.
Pls advise..
Answer:
Deleting the data log do not harm your delta load. You will be able to continue to do delta load without problems. You will not be able to do repeat delta of last request incase of data load failure as I mentioned in my previous message. There is an OSS note about all this with more details but I do not remember it right now. Try to search for it.
_________________
Ali H. Alwan
Atos Origin Middle East
Saudi Arabia
Answer:
Hi,
OSS note 643880 gives good information about it.
Br,
Tobias
Answer:
Ali,
CY looking to delete the records which were inverted ( + , _ ).
Am sure about deleting ODS change log shall not helps this requirement.
CY please kindly go ahead and let me know once its ok .
Regards
Martin
Answer:
Thank you all for the input.
I did some simulation on this issue, and found out that Ali was right.
If the ODS data was successfully updated to it's data target, there's no impact to the next data update with the same key.
Sorry for my mistake.
"Don't knock it 'til you've tried it." [/quote]