HCM Extracts - Using Secure Views in Data Group Filter Criteria
Queries around secured views in data group filter criteria
We have an HCM extract to fetch demographic and payroll information. The extract has a non-mandatory custom parameter tied to a value set. If the user does not select any value, we'd fetch the data across all the legal entities.
The root data group, is PER_EXT_PAY_EMPLOYEES_UE. I was looking at restricting data based on the user's roles in the extract by adding a secured view, here PER_ASSIGNMENT_SECURED_LIST_V to the data group filter criteria.
When I do it using the SQL for PER_EXT_PAY_EMPLOYEES_UE via a BI query, the data is restricted based on the user's roles. However, when we do it via filter criteria, the extract still pulls in all the data regardless of the security offered by the view.