Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OTBI - Work Relationship Start Date — Cloud Customer Connect
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 - Work Relationship Start Date

Question
10
Views
0
Comments
edited Aug 20, 2021 7:46PM in Learning

Summary

Trying to return a single line per employee instead of all dates of job change.

Content

The work relationship start date returns a row of data for employees for each job change. I.e. I was hired as an account exec 1/1/2020 and became a sr account exec on 1/1/2021. There would be a row of data for each. I am trying to figure out how I can filter it to only return the most recent entry so that each employee has a single line of data that shows their current job and when they started. 

Still pretty new to OTBI so I am kind of feeling around in the dark a bit. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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