How to select the time period when deleting EWA with report RDSMOPREDUCEDATA

[SAPSupport]

To reduce the size of the table DSVASRESULTSGEN in the solution manager, it is needed to remove the EWA with the report RDSMOPREDUCEDATA.
It is not clear how to select the time period in the report.
How to set the Select Time Period in case to delete all the EWA before 2023/12/31

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

There are 2 options available in the report RDSMOPREDUCEDATA.

• Date Interval: with this option, it is possible to define a time-period eg: 2023.01.01  ~ 2023.12.31, it will remove all the EWA sessions within this period. 
• Retain session from the last XX days: with this options, it is possible to define how long time it is needed to keep the EWA. Eg: Retain session from the last 180 days, it will keep the EWA for the recent 180 days and remove all the others

There is an option "Do not list selected elements", by default, this option is unchecked.
When running the deletion with this unchecked in dialog mode, it will display all the sessions selected to be removed. After you confirm the selection, it will actually remove the data. 
If you need to remove the data in a background job per the KB 2427041 - How to delete old EWA sessions according to retention times automatically through a job , please check this option so that the delete can be done in a background mode.