How to get the manager assigned to the department to show in a OTBI report

Claudia Linares L

Hi team!I need to add this manager to my data model, so please can you help me with what tables or code I need to add in my SQL? In my report, the column will be called "VP Manager". This manager is assigned to the Department. I appreciate your help!

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/26174/how-to-get-the-manager-assigned-to-the-department-to-show-in-a-otbi-report

Hi Claudia,

You can check the query on below link:

https://fusionhcmconsulting.com/2021/03/reports-bip-query-to-get-department-manager-name/

Thanks.

Claudia Linares L

Thank you so much @MandeepGupta! It was perfect! I was able to get the department manager.
Thank you,
Claudia