Need to Pull Final Approver on BI Report.
We have a request to pull the Final Approver on a BI Report.
The report has been built using SQL and is pulling from the fa_fusion_soainfra.wftask to get the next person to approve.
When the user looks online at the requisition they can see the full approval tree to final approver.
Is there a way to create a SQL Data Model in BI Reporting to pull this same information?
The fa_fusion_soainfra.wftask will show the next person to approve, but not the full approval tree. Can a query to created to pull the full approval tree?