Aggregated Security in OTBI

Content

Hi all

A question on the aggregation of security in OTBI. We have a requirement where HR users may have access to different groups of employees via their Data Roles. e.g:

• Role "GB HR Admin" gives them access to UK employees
• Role "US HR Admin" gives them access to US employees
• When accessing employees via Person Management they can view employees from both countries

When viewing data in OTBI however, the requirement is for them to only return employee records based on the Data Role the report has been shared with, rather than the aggregate employee access. Is there a way to achieve this requirement or would the report always return the aggregate data?