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
