There is a new query available for Human Resource data warehouse users, ReportsTo.bqy. This query shows who employees report to as well as their account distributions. The query is set up to select by department, but Human Resource data warehouse users can save a copy of the bqy to their user folder and modify it as desired. The bqy include some helpful pivot views of the results as well.
Thanks to Denise DeSouza and Elaine Moore for developing this new query.