BI Report to show all Employee/Manager Hierarchy

Summary

BI Report to show all Employee/Manager Hierarchy

Content

Hi Community

I am trying to build a report which shows all employees and their managers.. I need it to show the employee/Manager hierarchy however, i have had limited success.

Has anyone developed such a report or have any tips on how this can be done?

Sample Output reequired

Employee	Line Manager	Employee Job Level	Manager Job Level
MarK Al	John Smith	40	50
Chris Small	John Smith	40	50
Erin Wright	John Smith	40	50
Erica Yell	Erin Wright	30	40
Andy Ahn	Erin Wright	20	40

 

Thanks in advance