Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here

Need help with SQL query (OBIEE Dataset)

Oct 2, 2020 6:04PM edited Oct 2, 2020 6:04PM in Reporting and Analytics for HCM 6 comments

Summary

Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)

Hi All,

I am trying to build a report to show data for an employee on 2 different dates (ie: Data from Jan 1, 2020 and data from Jun 30, 2020)

some fields to be shown are:

location, department, people group, comp group, shift schedule, etc.

I think I have the query to pull the data for the 2 different dates but now I need to only pick up those records where any of the fields have changed

If no change has happened between the 2 dates, then I don't want to show the employee on the report.