For more information, please refer to this announcement explaining best practices for getting answers to questions.
Hierarchy Traversal in BI Data Model Report
Content
Please refer to the images attached.
Referring to IMAGE1. In column level we want to show business unit in level2(by default on opening the report) from the organization tree hierarchy. Suppose there are BU1 Level 0 to BU1 Level 5. Like when we click in the BU1 Level2 we would be able to traverse up/down the hierarchy from BU Level 0 to BU Level 5 and select any one of them to show the person count. Is it possible in BI data model report to achieve this?
Similar is the requirement for rows, where we want to open the ‘sub job function’ by clicking on the 'Job Function'. For Example: By clicking on the 'Job Function1', we can open the 'Sub Job Function1'. Something like the one shown in the IMAGE2 .