Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence

Categories

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

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

Accepted answer

21

Views

2

Comments

Claudia Linares L

Claudia Linares L Rank 3 - Community Apprentice

Jun 10, 2025 6:27PM in Oracle Transactional Business Intelligence

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!

Tagged:

0

Best Answer

MandeepGupta Rank 8 - Analytics Strategist

Jun 11, 2025 7:22AM Answer ✓

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.

2

Answers

Claudia Linares L Rank 3 - Community Apprentice

Jun 11, 2025 4:47PM

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

1