Data Secuirty in BI using different data secuitry on role configurations
Am having this case here, Am using Secure View in my query (PER_ASSIGNMENT_SECURED_LIST_V) and am having 2 different data security on roles
1st Person Security Profile ( Secure by AOR - Legal Employer type)
2nd Person Security Profile (View all)
the 1st configuration sometimes it returns correct data - 2nd configuration non of them return correct data.
At the same time I checked that the assigned employees have got the correct AOR on there assignment.