Categories
How to fetch and display employee details in rows based on manager hierarchy in OTBI reports.
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.
Answers
-
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:
0 -
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
0