Oracle Fusion AI Data Platform Forum

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

Having an issue to achieve Hierarchy based Absence reporting in FDI (Direct and Indirect)

Question
2
Views
0
Comments
Priya Parthiban
Priya Parthiban Rank 2 - Community Beginner

Need to create a dashboard to show all direct and indirect managers under a selected manager, along with their combined direct and indirect reportees’ absence data. Since the Manager Hierarchy in FDI doesn’t return data for me, I explored alternatives: Using the Position Hierarchy (Top Position as filter and Manager Name from Assignment Manager List in the table) gives correct absence aggregation and manager coverage; however, it also displays ancestor‑level managers (for example, Group Executives and COO when selecting Executive Director). Could you please advise if it’s possible in FDI to restrict the output to only descendant‑level managers while still aggregating both direct and indirect absence data?