on 01-16-2006 10:56 PM
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
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.
...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi BWer,
What u mean by "Since we do not have the selective deletion of data as we have in cube" ??
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.