OTBI Analytic - Manager plus email and department details
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