cancel
Showing results for 
Search instead for 
Did you mean: 

Shrink the ODS Data along with change log ?

Former Member
0 Kudos

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.

Thanks,

BWer

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi BWer,

what's your bw versio ? 3.x ?

we can do 'selective' delete in ods, ods->manage->contents->there is button 'selective'.

help.sap.com

'delete change log'

http://help.sap.com/saphelp_nw04/helpdata/en/6d/1fd53be617d524e10000000a11402f/content.htm

'selective deletion'

http://help.sap.com/saphelp_nw04/helpdata/en/76/9fd60be17411d4b2d90050da4c74dc/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/ca/5c7b3cbd556915e10000000a114084/content.htm

1. yes

2. no selective here, better ods-'delete data'

3. yes, will you ?

so 4. 'selective' deletion.

no.1 or no.4 i think ....

hope this helps.

...

Deleting Data from the ODS Object

Use

In order to delete data from an ODS object, you have several different options. All of these options can be accomplished from the administration of the ODS object . The option you choose depends on your application scenario.

If you want to delete entire requests that are incorrect, then choose Delete by Request. With this, requests that are not activated can be deleted from the activation queue, or activated requests can be deleted from the active data table and the change log.

If you only want to delete individual fields instead of an entire request, choose Delete Selectively. With this, you can delete data, for example, from a time period that is no longer used. In doing so, only data from the table for active data is deleted, while the change log remains unchanged.

If you only want to delete data from the change log, choose Delete from the Change Log. With this, you can reduce the scope of the change log if several requests have already been loaded, and only a limited history needs to be retained. Thus, the data volume of the change log is reduced.

...

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi BWer,

Answer for your 1st question.No.

Solution.

Go to your ods, right click > Manage > enviornment (in menu) > Delete change log data > /h in T.code > Double click on the required records > Press F7 > Double click on the DELE or enter DELE in the fields contents > Click on the change icon > Delete entries.

Q2.

Yes but not selectively.

Q3.

Yes.

Let me know if you have any thing else.

Thanks

Ramu

Former Member
0 Kudos

Hi BWer,

Selective deletion on ODS is possible in 3.0B. I dont know abt the previous release. Which version ur working on?

Sriram

Former Member
0 Kudos

hi BWer,

What u mean by "Since we do not have the selective deletion of data as we have in cube" ??

Regards

Sriram

Former Member
0 Kudos

Sriram,

i mean selective delete is not there in ODS as we have in cube..

Regards

BWer