Categories
- All Categories
- Oracle Analytics Learning Hub
- 18 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 229 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 85 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
HCM Data Security

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
Best Answer
-
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
2
Answers
-
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.
1 -
Amazing. Thank you. Is there a way of using these custom roles as a selector within a report to view by?
0 -
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?
1 -
Very useful.
Thanks for sharing @Silvio Garber-Oracle!
0