Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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.
0