Cross Tab performance

Migrateduser

Hi,

I've recently created a cross tab in my report and the performance is really bad. I initially created a basic table to display the data set (raw records) which returned the data in under a minute. I then created a data cube based on this data set and a corresponding cross tab to display, and it either hangs or returns records (if i filter the data) much much slower.

Any idea why the raw data is able to be retrieved quickly yet the data cube/cross tab takes orders of magnitued longer..or not at all?

Thanks in advance,
Dan