Skip to Content
avatar image
Former Member

How to schedule deletion of statistical data

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 17, 2009 at 04:48 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sorry for my misunderstanding...I thought this is a FM: RSDDSTAT_DATA_DELETE, But now realized it as a program which is available in BI 7.0.

      Thanks,

      Ramesh

  • avatar image
    Former Member
    Jun 17, 2009 at 04:46 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2009 at 03:46 PM

    Dear,

    We do not have the program "RSDDSTAT_STATISTICS_DELETE" on our system.

    Could you maybe post the code in this thread? Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 22, 2009 at 05:46 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded