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…

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…

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 . .

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…