Filters on multiple SA are not working
We are trying to create a new OTBI analysis, where we have a requirement to pull both the Worker assignment details and the person VISA details.
So we used Workforce Management Person real time SA and Workforce Management - Worker Assignment real time. We need to filter the results based on 'Work Country' and VISA creation date. These 2 filters are not working together since they are from different SA's. Work country is not available in Person Real time subject area so we are getting work country from Assignment real time SA.
For ex: There is an employee who is currently working In India, and he has entered his VISA/Workpermit details in HCM on March1st. Business wanted to see the newly created VISA details of India employees on a weekly basis. Inorder to achieve this i had to give a filter on VISA creation/last update date to know the employees who have entered their VISA information in the current week and on top of that i had to filter this population by Work Country wise.