You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need help with SQL query (OBIEE Dataset)

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


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.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!