Work Schedules OTBI - employee missing from analysis if no work schedule
Work Schedules - if employee does not have a work schedule they are missing from the analysis
We create OTBI analysis using Worker Assignment Real Time and Salary Details Real Time. Customer also wants to include the Work Schedule, however when we add this from Person Details Real Time, the results show all work schedule history, we only want the current one, or blank if it's missing. If we filter on Primary = Yes, then employees who do not have a work schedule are missing from the report. We need to retain all employees in the analysis, and include current work schedule for those who have one.