How to fetch and display employee details in rows based on manager hierarchy in OTBI reports.

Sifat Shaikh

There is a requirement to fetch and display below mentioned fields in an OTBI report based on manager hierarchy.

Business Unit	Cost Center	Cost Center Manager	Name	Title	Job Name	Department	Job Level
A	10	X	Employee	a	d	g	1
A	10	X	Level 1 Manager	b	e	h	2
A	10	X	Level 2 Manager	c	f	i	3

What are the steps to fetch this Name column hierarchy structure based on manager hierarchy as shown in the above table. The requirement is to display employee details in one row followed by his/her L1 managers details in the next row, followed by the L2 manager details, so on and so forth.

Julian Challenger-Oracle

This should have been posted in the HCM Reporting and Analytics forum where it would have received more immediate attention. I suggest that you open the Workforce Management - Worker Assignment Real Time subject area and explore the sub-folders in Worker and maybe the Organization dimension too.

You can find more information on using HCM OTBI here:

https://community.oracle.com/customerconnect/discussion/477699/otbi-resources

Aarthi Natarajan-Oracle

Hi @Julian Challenger-Oracle

Workforce Management - Worker Assignment Real Time is returning "No results". Also this subject area is returning "Resource Organization Hierarchy", what we want to report on is "Employee Hierarchy". Is there a way we can build OTBI report to show Manager-Their Direct Reportees details?

Regards

Aarthi Natarajan