Query Time Out

[bo5i]

Hi, I have few reports which use custom group(around 20 groupings based on a metric value say ranges) and go against 15GB fact table. The report comes out with an error saying report execution timed out. I tried increasing it to 60 min, but still of no use. These reports are run once in a month. Any suggestions on how to handle this situation.

Thanks

 

[chael]

you could set the report timeout to -1 and schedule the reports to run overnight...