Delete Multiple Request from Cube Loaded in a Day but Keeping the Latest Request

Hello All,

Scenario: Dataflow: PSA --> Infocube. There are multiple request that is being extracted in a single day and we need to keep the latest request and delete all other request for that day. So, in that way we will have 30 request in a month.

How to delete all the request for a day, but keeping the latest request in the cube but not deleting the request from previous day. I guess this can be achieved using Process Chain - Delete Overlapping Request from Infocube. I did some testing, but unable to achieve the desire result. Can anyone suggest some options.

Thanks,

Mirza