The Diffuser Architecture provides program /BTR/MDR_INSTANCE_DELETE, this program allows you to completely delete the stored result sets or MiniCubes of data for one or more Diffuser instance runs and the result sets of all their corresponding intervals. Alternatively, you can choose to delete only the result sets of the intervals of an instance run. If you don’t need results at interval level you can choose the second options since the result sets at instance level are an aggregation of the intervals.
To run the program /BTR/MDR_INSTANCE_DELETE you need to have added the programs you want to delete the data for in the table /BTR/PROGARCH using SM30. This allows you to restrict by program and numbers of days of instance runs that are stored, the configuration table makes it difficult for anyone to accidentally delete results. For example a sales team might want to see their historical data for the last 30 days and you can add 30 as the limit, then when running the /BTR/MDR_INSTANCE_DELETE it will only delete data for that program that is older than the 30 day limit.
It is recommended to schedule this program to do regular cleaning in your system to avoid accumulation of unnecessary historical data.
If you only need to delete one run the “Delete” functionality for individual instances mentioned in Administering Diffuser Programs can be useful.
Post your comment on this topic.