OTBI Analysis from Top to Bottom Mgr Hiearchy

Summary

Need an OTBI Analysis for the Mgr Hierarchy from Top to Mottom based on the selected Manager

Content

Hi Team.

We have requirement to print the below Manager Hiearchy in OTBI analysis only. Please Let me Know how can we achieve this ASAP.

Let me show manager hierarchy: if the manager Hiearchy is like this shown below, the Detailed analysis in the table shoudl be output on slecting the manager

 

 

                       M1

                   /    |     \

                 M2  M3   M4

                / \                \

    M5  M6           M7

                                   /    \   

                                 M8  M9

 

Detailed Report Manager Table:

Manager Name	Column 2	Column 3	Column4
M1	M2	M5
		M6
	M3
	M4	M7	M8
			M9

 

Please help us with analysis of achieving this