Latest records in Infocube after delta

Hi Guys,

I was wondering what the way was to be able to report on the latest available data in a infocube after a delta load. In my scenario, I need to display the service requests which are still "Pending". The status of the "Service Requests" is changed from "Pending" to other statuses in CRM and then a delta load is done daily.

But since the infocube also keeps the previous available status as a record as well as the new status, when I restrict on the status to pending, it brings abt the "Service Request(SR)" which has a different status too as it also has a record with status "Pending". How can I restrict these SR from not being displayed as its latest status is "not Pending".

Thanks,

Doniv