Oracle Communities

Oracle Analytics and AI

Child Item

Need a supervisor/Bottom up dimension table or any table which fetches Level 1/level2/Level3/level 4

Requirement: Need a supervisor/Bottom up dimension table or any table which fetches
Level 1/level2/Level3/level 4 manager Names column data in Fusion data intelligence seeded subject areas
to implement custom security context/assignments to restrict Top Manager level names
Note: We have bottom up Hierarchy table which contains Level 1/level2/Level3/level 4 manager Names ,
we tried to implement custom security context/assignments to seeded subject areas which didn't work
Current FDI version :25R2

Find more posts tagged with

Needs Votes

Fusion HCM Analytics

Status: Needs Votes

Comments

Raghavendra Raghunath-Oracle

Hi @User_G7OK5 have you checked out the seeded dimension related to bottom up manager hierarchy

HCM - Workforce Core > Hierarchies > Bottom-Up Manager Hierarchy

Raghu

User_G7OK5

Hi Raghu ,

Yes we have tried with Bottom-Up Manager Hierarchy table for testing purpose we selected Level 2 column but security context did not work we could not restrict data for seeded subject area while creating reports in custom FDI user url . We just need a seeded dimension table which contains details of level 1..level 2..level 3 column to restrict Managerial data

Following is the screenshot

Raghavendra Raghunath-Oracle

Hi Reena, you just need the table name? - DW_MANAGER_CF_DH

Raghu

User_G7OK5

I don't require table name as i have table names from oracle docs ,As hierarchy table is not working to restrict data using custom security context for seeded subject area , can we get any other dimension table which contains data same like Bottom up hierarchy table in future release& in present release . https://docs.oracle.com/en/cloud/saas/analytics/25r3/fahia/chapter-introduction.html#GUID-7D511E0C-7E34-4450-A117-F0001A74D0EF.WE .

User_G7OK5

Using the (HCM - Workforce Core->Manager Information->Manager Name) subject area & column name we have restricted the Manager data
but Unable to restrict Hierarchy table columns
If their is any new seeded dimension table or existing which has same data alike bottom up hierarchy table in latest releases or Future releases let us know.

Following is the sample example screenshot where I restricted Manager Name which has worked.

Raghavendra Raghunath-Oracle

Hi Reena, I don't think I get your ask correctly. What prevents you from using the existing table that has the bottom up manager hierarchy?

I will also forward this to my colleagues @Nupur Joshi-Oracle and @Ravi Guddanti-Oracle who have a better handle on asks related to Security

Thanks

Raghu

Nupur Joshi-Oracle

Hi Reena , what is the exact requirement ? You want data security to be restricted by manager level ?

User_G7OK5

Yes we want to secure the data based on supervisor Hierarchy

For Instance, There is an HR called John and we have resticted him to see the data only till Mohan Level, he will not be able to see any record above Mohan. This restriction we have done in AOR using Supervisor hierarchy and same is working in OTBI also.

Mohan is CIO
Jimmy reports to Mohan -- John can see his record
Amit reports to Jimmy -- John can see his record
Uday reports to Amit -- John can see his record

But

Mohan reports to Priyanka -- John should not be able to see Priyanka record
Priyanka reports to Harsh -- John should not be able to see Harsh's record

Based on above requirement, we found bottom up hierarchy table which was providing Level based managerial data in FDI to restrict which did not work using custom security context .