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

Max assignment logic not working as expected in OTBI Analysis in Workforce Management Subject Area

Received Response
edited Aug 2, 2018 2:04PM in Reporting and Analytics for HCM 16 comments


We have several requests to bring in an employee’s max effective row in OTBI.     We could use the Workforce Management Worker Assignment Real Time, but the issue with this and our requirement is that the ask is to see an active assignment if the employee is active or the max inactive row if the employee doesn’t have any active assignments.   We added logic into our analysis to get the max assignment start date:

("Worker"."Assignment Start Date" IN (MAX("Worker"."Assignment Start Date" BY "Worker"."Person Number")))

This logic was working as expected unless one of the prompts was selected. 

Howdy, Stranger!

Log In

To view full details, sign in.


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