Employee's manager in a certain grade

Summary

making a query for a manager in certain grade

Content

Hi all.

I need to supply a report (preferably an OTBI) that indicates for each active employee who is his manager in a certain grade.
for example a column for the employee's Corp VP manager, a column for the employee's Director manager and so on.
As I understand that, it requires to use a loop across the hierarchy till relevant manager is picked, but I struggle to make it work.

Does anyone have any similar implementation or guiding for this matter?

Thanks.
Ben.

Version

18b