Forum Stats

  • 3,770,393 Users
  • 2,253,101 Discussions
  • 7,875,437 Comments

Discussions

Building report with latest/recent records

User_29H9N
User_29H9N Member Posts: 22 Blue Ribbon

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

Tagged:

Best Answer

Answers