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

Content

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.