Automatic Drill Down Based on Role Level Security

have an employee hierarchy table. I would like have a visual that drills down to thier level in the hierarchy automatically based on role level security. I think that this can be possible if I were t...