Dynamic Hierarchical Reporting with Recursive Common Table Expressions

Design a robust SQL solution for a multi-level organizational hierarchy where employees can have multiple managers and complex reporting structures. Create a recursive CTE that can traverse unlimited organizational depth, calculate reporting chains, and generate a flattened organizational matrix. Include performance optimization techniques for handling organizations with 10,000+ employees, and implement error handling for circular reference scenarios.