Report to track Specializations activities status by employee in OTBI
We need to create in OTBI a report where to track the completion status of each activity in an specialization for all employees assigned to that specialization.
When I add the fields:
SELECT "Worker"."Employee Name" saw_0, "Learning Items"."Learning Item Name" saw_1, "Specialization Activities"."Activity Name" saw_2, "Assignment Status"."Sub Status" saw_3 FROM "Workforce Learning - Learning Management Real Time"
The substatus reflected in the activities is taken from the specialization, not by each activity.