Our CFO and financial analysts want all the raw data (flattened into 2-dimensional tables) to import into Excel and pivot to their heart's content. They don't know what they're looking for specifically, so they don't know what subset or rollup to ask us for.

Our data isn't so big that they would get million-record exports, but until Excel 2007 came out we were very badly stymied by the 65,000 row limit. 400,000-row exports are not abnormal.

We've tried but failed to find a web-based front-end pivot table environment that is as powerful and flexible as Excel.