Getting the Counts of Learners based on Manager Hierarchy in OTBI Analysis

Content

Requirement:

When the managers runs the analysis,  they should only see their direct reports and counts of the Learners under their Direct Reports. When they drill down on any Direct report, the second level reports should appear and the counts of further down levels.

Example:

Manager runs the report and see the direct reports and the counts.

Manager Name	No Offering Selected	Pending	In Progress	Completed
John	50	76	86	113
Charles	47	79	97	114
Nick	48	83	101	128

Manager drills down to John and should see the direct reports of John

Manager Name	No Offering Selected	Pending	In Progress	Completed
Sara	50	76	86	113
George	47	79	97	114

This should go on until the manager drills down to last level.