HCM Data Security

Dan L Ryan

Hi all

We have a requirement where users have both Line Manager and HCM Org Data Security. As far as I am aware, it is only currently possible to secure the security setting at an environment level to either Most restrictive which will only show the Line Manager Hierarchy or Least Restrictive which will show both at the same time.

Has anyone managed to come up with a solution so a user can select which security they want to secure/view the report by? What I want to avoid is needing 2 versions of each HCM workbook, one with HR Org data security, the other with Line Manager data security.

Thanks

Silvio Garber-Oracle

Hi buddy, we´ve recently discussed this scenario in our CEAL Guidance Office Hours. Please take look at the HCM Security Part 2 video at

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours 2025 - Oracle Video Hub

Regards, SG

RVohra

Another approach is to try by building a report/dashboard prompt that lets the user select “View by Line Manager” or “View by Org.”

• Behind the scenes, the prompt drives the data filter logic.

Dan L Ryan

https://community.oracle.com/products/oracleanalytics/discussion/comment/71537#Comment_71537

Amazing. Thank you. Is there a way of using these custom roles as a selector within a report to view by?

Silvio Garber-Oracle

You can use runtime values as a selector using Parameters. Check this video.

Going Further in FDI Series - Oracle Video Hub

As for security, it´s controlled by job groups. Is your scenario not covered by the security video?

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/71537#Comment_71537

Very useful.

Thanks for sharing @Silvio Garber-Oracle!