I am using the data source '0CRM_SRV_REQ_INCI_H' to extract the service requests created. And based on which i need to create SLA report in BI. I have extracted the data from the mentioned DS and loaded to DSO '0SRQ_DS10' and then to cube '0SRQ_C10'.
My requirement is to populate the report with the number of ticket/request open, inprocess, close as on given date, like below.
Service ticket '123456' is created on 1st april and it is loaded to BI and now my report gives all the ticket no with status where user have entered the selelction value 2nd april. Am picking all ticket less than user entered date.
Now the service requet is closed in CRM and if it comes to BI with new status on 3rd april and if i pull out the report in 4th april am getting two entries for ticket '123456' but i need to show only 1 record with closed status which is recent one.
And if the user enters 2nd or 3rd april i should display one record with status 'Open'.
How to acheive this?