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

OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?

Accepted answer
54
Views
9
Comments
edited Aug 17, 2020 1:43PM in Reporting and Analytics for HCM 9 comments

Summary

History records of a person

Content

Hello,

Can anyone please help me with the below scenario?

I would like to get previous job changes/history (and few additional columns as well like Dept, Business Unit, Start Date and End-Dates) of a person within OTBI itself and not through logical SQL route or BIP.

By default, OTBI picks-up the latest record based param_effective_date. So, I always get the 4th record.

In the below example, I would like to have all the first three records.

S.No. Job Title Date From Date To
1 Engineer 1 01-Jan-2020 02-Feb-2020
2 Engineer 2 01-Mar-2020 31-May-2020

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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