on 06-17-2009 5:31 PM
Hi ,
Currently we are collecting the statistics of all Infoproviders/Queries/workbook. Now instead of maintaining all the statistics, I would like to schedule the deletion of statistics which are older than certain period? I know there is a manual way to delete these through RSA1-> Tools -> Settings for Statistics..But I am looking for some thing which can be scheduled periodically(automatically)?
Regards,
Ramesh
Hi Ramesh,
Create a job using program RSDDSTAT_DATA_DELETE.
Schedule it to run with a variant.
In the variant you can maintain the settings regarding the time frame from when you would like to retain the data.
You can schedule the job periodically.
Please refer to the link below for further details.
[ RSDDSTAT_DATA_DELETE|http://help.sap.com/saphelp_nw70/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm]
Hope this helps,
Best regards,
Sunmit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ramesh,
RSDDSTAT_DATA_DELETE can be used in 7.0 to delete the Statistics from the backend tables, but this does not delete the Statistics you have collected into the Business Content cubes, and it is recommended to do this periodically because old Statistics data really has little value.
There is no program to do this--you will need to perform a selective deletion on the infocubes (assuming you have properly compressed the requests). I do not believe there is Process Chain Type that does selective deletion. Perhaps someone knows of an ABAP to do selective deletion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
We do not have the program "RSDDSTAT_STATISTICS_DELETE" on our system.
Could you maybe post the code in this thread? Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can delete the data of the cube from F or E table at the start routine. Means whenever you will load the data it will check the data for the particular date range in cube, delete those data and load the fresh data.
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.