Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Employment Position History Report — 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

Employment Position History Report

edited Aug 3, 2018 1:47PM in General Transactional Reporting (OTBI) 1 comment


Grouping data


I am creating a BI Report that basically lists out all the Jobs an employee has had during their employment, so of course my initial grouping is EMPLID. (Sample XML File is attached) My issue is that if an employee starts with JOBCODE1, goes to JOBCODE2, then back to JOBCODE1 and then JOBCODE3 the report has to put out 4 lines. In addition the report needs to calculate the length of time in each position. It does this by using the EFFDT from the first line of each JOBCODE and the EFFDT from the last line of the JOBCODE calculate


Howdy, Stranger!

Log In

To view full details, sign in.


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