BIP - Organization Hierarchy

Summary:

Hello,

Does anyone tried creating report in BIP with organization hierarchy details? For example:

Enterprise

Division

Business Unit

Department Level 1

Department Level 2

Department Level 3

Department Level 4

Department Level 5

Department Level 6

Department Level 7

Department Level 8

Could you please share your SQL to me? That would be a great help. Thank you so much

Content (required):

Hello,

Does anyone tried creating report in BIP with organization hierarchy details? For example:

Enterprise

Division

Business Unit

Department Level 1

Department Level 2

Department Level 3

Department Level 4

Department Level 5

Department Level 6

Department Level 7

Department Level 8

Could you please share your SQL to me? That would be a great help. Thank you so much