Need to display second from Top Manager in OTBI report

Summary

We need to display Performance Management related data in OTBI report. In that one of the field value, need to display second from Top manager.

Content

Hi All,

 

We have a requirement in Fusion Performance Management module like, need to display second from top in the Supervisor hierarchy for each employee (i.e. Top would be common, but the second from the top) in the OTBI report.

 

For ex:

-------

Employee-->Manager-->Next Level Manager-->Next Level Manager-->Next Level Manager (Top Manager)

1. John           David          Michael                              Johnson                  Paul

2. Andy           Rock          Murray                                Debbie                    Paul

 

In the OTBI report I need to display data,