Question:
Hi folks,
it's quite easy to clear / delete data fom an ODS. Right-click on the ODS
-> delete data.
Does anyone know, how I can schedule that action ? I often have to clear my ODSes and would like to schedule that at night.
I could write a small abap report that clears the table, but I don't know, what happenes furthermore when one clicks on the ODS to delete it.
I browsed the OSS, the forum and the SAPhelp. No chance.
Thanks.
Answer:
Perhaps you can try via 'Process chain'...
Otherwise small ABAP can help...
in this ABAP you can simulate the manuel actions.
_________________
Kind Regards/Vriendelijke groeten/Amicalement,
Wim
Answer:
>Otherwise small ABAP can help...
I don't know, whether a small ABAP can help or not. Seems that much more happens by using the manual action let alone the ODS (-> e.g. roll-ups, initial loads and more control functions in other tables)
_________________
not the things we don't know make us fall -
but those we think to know by mistake
Answer:
You can schedule the data deletion of an ODS using a process chain.
Create a new process chain. Under Data Target Administration, select the object "Complete Deletion of Data Target Contents" and add it to you chain. (Creating a new variant for it.)
In this object you can add one or more ODS, or InfoCube objects to have the contents deleted. Then you can save and schedule your chain.
I do it all the time in our dev. environment for testing.
Answer:
>Create a new process chain.
I'm sorry, but I've never created a process chain.
Can you please tell me the transaction code for that ? Couldn't find it.
I also could't understand how to create a "variant" for the deletion. It's only an option in the menue of the ODS.
Thank you.
_________________
not the things we don't know make us fall -
but those we think to know by mistake
Answer:
RSPC is the transaction.
Click new to create a process chain.
Search the online help (I forget where the process chain info is in help) for process chains and you will find more information.
Once you get to selecting the "Complete Deletion of Data Target Contents" for inclusion into your process chain, you will understand the part of "creating a variant" (fairly straightforward once you see it.)
I would recomend learning more about process chains, they can be very powerufl and very helpful.
Answer:
1. do u have to drop the data everytime u load the new data in the ODS?
2. If so this could be achived in the infopackage - Data targets and click on the Sigma button and u will get a popup screen with options select the one that suits ur need.
_________________
Sunand Kosuru
Answer:
1. I suppose this is possible for Cubes only since u can overite in ODS which generates change log so there is no need to delete the data from ODS.
2. Why do u want to delete data from the ODS on a daily/schedule basis?
_________________
Sunand Kosuru
Answer:
Hi Bob,
Thanks. When I am trying to actiavte the process chain that I have created, I am getting the following message: "Process has no predecessor".
I have two nodes in the process chain, "Start Process" and "Complete Deletion of Data Target Contents". and a line conecting "start" node to the "Deletion..." Node. What am I missing?
Thanks for you help.
- Mcake
Answer:
>Why ...delete data from the ODS on a daily/schedule basis?
I do not use any content - have built up all the structures in BW myself. I need to schedule that because I often have to test complete fresh loads from the sourcesystem.
I work with BW 2.1C - Transaction RSPC doesn't exist. And I couldn't find something about Process Chains. Maybe there is another term for that in German. Is it a transaction about real "processes" or about "jobs" ?
_________________
not the things we don't know make us fall -
but those we think to know by mistake
Answer:
Process Chains only work as of 3.0 ...
Answer:
Thanks EL BELGIO.
I just recognized that, too. We have a Testsystem of BW 3.0A - there the transaction works and everything is clear.
Any advices for poor 2.1C-Users like me ?
Thank you.
_________________
not the things we don't know make us fall -
but those we think to know by mistake
Answer:
I assume that behind the "Delete Data" functionality there is a function module (probably RSAN_ODS_DATA_DELETE). Try it this way
cheers,
El Belgio
Answer:
Okay - had a look at the coding - this will work.
So i'll write once more a small ABAP until we will be released to BW 3.0X
Problem solved. Thanks once more.
_________________
not the things we don't know make us fall -
but those we think to know by mistake
Answer:
oh - i was too fast.
The function module doesn't work properly. It only deletes the data from the ODS-Tables. But the information stuff belonging to the ODS(requests,PSA,RollUp, SystemTables...) is only being deleted by using the CLASS cl_rsd_dta-> Method is if_rsd_dta~delete_data
CALL METHOD my_object->if_rsd_dta~delete_data
Now the problem ist solved.
Scheduling ODS- Deletion completely - any time we want in 2.1C
_________________
not the things we don't know make us fall -
but those we think to know by mistake