Skip to Content
Former Member
Jan 16, 2006 at 10:56 PM

Shrink the ODS Data along with change log ?


Hello BW Experts,

We have a requirement to delete ( 3/4 ) the ODS data in Q, so that a system copy can be done to Dev. Wondering what are the possible solutions.

1) manually delete the requests in the ODS. But Does it delete the Change log though ? if not then how do we delete 3/4th of hte change log?

2) manually delete the change log in the se14, is this possible how?

3) can we write a program / fuction module to achieve this, in that case is there a generic name / method for addressing all the ODS changelog (could be more than 200)tables in the delete statement

Since we do not have the selective deletion of data as we have in cube, is there any other method.

Any suggestions appreciated.