a report based on one of our flattened table takes too long to load, as a flattened table it should not take that long. Any idea why it is doing that? Anyway to speed it up? Any pointers appreciated

Even though the table is flattened, load times can still be affected by factors such as table size, missing indexes on filter or sort columns, or aggregations being calculated in the report rather than pre-aggregated in the table. I’d recommend reviewing indexing, query execution plans, and whether any heavy calculations can be materialized in the table to improve performance.

FYI - turning on caching sped up the load significantly