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.
