FMS — Reporting Server

Problem

Pivot dashboards were calling stored procedures directly. Every filter change meant a 20–30 second wait — and complex drill-downs could time out entirely. Analysts were abandoning the product.

Approach

1. 01Architected a FastAPI service in front of ClickHouse, shaped specifically for FlexMonster's data contract.
2. 02Built a pipeline that extracts only the needed subset of large SPs, transforms it server-side, and returns a response sized for the pivot — not the full result set.
3. 03Added query plan caching and smart slice invalidation so repeat filters are effectively free.

Outcome

Report load times dropped 60% versus direct stored-procedure calls. Query response improved 70%. Analysts started exploring data that had previously been 'too slow to touch'.