Hello,
I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case).
The Analysis is to get “Enterprise Hire Date” for all the employees except those who were rehired, and for them bring the “Employee Hire Date”.
The challenge is that an employee can have additional HR actions since the Rehire action, and then we might “miss” the Rehire and fetch the wrong date.
I've used the following calculated field:
CASE
WHEN "Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."Action Code"='REHIRE'
THEN "Workforce Management - Worker Assignment Event Real Time"."Worker"."Employee Hire Date"
ELSE "Workforce Management - Worker Assignment Event Real Time"."Worker"."Enterprise Hire Date"
END
any ideas?