OTBI Analytic - Manager plus email and department details

Hello all,

I have been asked to create an analytic that will show the following Columns;

Manager Name Manager Department Number direct Reports Number indirect reports Manager email Address

I seem to be struggling - all the subject areas appear to be presented from the perspective of reporting details of workers - not the details of the managers. This might work if I could find a way to identify if a worker is a line manager.

Does anyone have any pointers?

Thanks in advance