We would like to build a report in OBIEE which should show only latest records i.e. records with max(end_timestamp) for the given Jobname without any RPD/DB Changes.

How the analysis or report should be created?

Eg. source data

JobName Status     end_timestamp Comment

ABC   Completed    07:00    C1

PQR   Completed    08:10    C1-junk

PQR   Failed     06:30    C1-junk-old

XYZ    Failed 05:00    C1-xyz

XYZ Completed 04:00 C1-xyz-old

==== OBIEE report should only produce

Jobname Status end_timestamp Comment

ABC    Completed    07:00    C1

PQR Completed 08:10 C1-junk

XYZ    Failed 05:00    C1-xyz