Create OTBI report to fetch the 2 recent most records for a person's legal employer change
Summary
Create OTBI report to fetch the 2 recent most records for a person's legal employer changeContent
Hi Experts,
I need to create an OTBI report that shows the current Legal Employer & the previous Legla Employer of an employee in a given date range.
Say in betweeen Jan 01 and Feb 15 there were two Legal Employer changes for an employee.
If the user gives this date range in FROM and TO parameters then in a single row I need to display person number,name, hire date, past LE & Current LE.
I'm using WorkForce Management- Worker assignment event subject area?
Any idea on how to achieve this?
Tagged:
1