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

Employee historical rows

Received Response


Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull historical records. but if a job code had effective date changes over time or a department changed overtime, it only shows current information in the structure table. how can we run a historical report in OTBI that also pulls in the workforce structure information based on effective date rather than just current info.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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