Oracle Fusion Data Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Fusion Data Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Needs Votes
48
Views
8
Comments
User_G7OK5
User_G7OK5 Rank 2 - Community Beginner
edited Aug 12, 2025 1:58PM in Oracle Fusion Data Intelligence Idea Lab

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

Tagged:
1
Up
1 votes

Needs Votes · Last Updated

Comments

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    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
    User_G7OK5 Rank 2 - Community Beginner
    edited Sep 9, 2025 1:54PM

    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

    image.png
  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

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

    Raghu

  • User_G7OK5
    User_G7OK5 Rank 2 - Community Beginner

    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
    User_G7OK5 Rank 2 - Community Beginner
    edited Sep 9, 2025 3:22PM

    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.

    image.png
  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    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
    Nupur Joshi-Oracle Mod

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

  • User_G7OK5
    User_G7OK5 Rank 2 - Community Beginner
    edited Sep 10, 2025 11:06AM

    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 .