Evaluation bi publisher reports what is the security table to support managers direct report view?
We have a bi publisher report ,where we extract population of employees and their evaluation.
Issue : the report is run by managers ,we wish that each managers will be able to view in the report Only his direct and indirect reports.
In the DM query of the report ,we added 2 conditions of security tables that we always add and for human resource it always works - and the HR specialist only view the employees by aor) but for managers - it doesn’t work. - those -PER_PERSON_SECURED_LIST_V, PER_ASSIGNMENT_SECURED_LIST_V.
What security table of performance that we can add please ?