Planning Analytics (TM1) Data Source Painfully Slow

[froodyo]

We have been creating reports using Planning Analytics data and I am at a completely loss when it comes to the speed of these reports. If I look at the data in Architect I can pull it extremely quickly, but as soon as we create the report in Cognos v11 our report of the data comes to a crawl. We have upped the JVM Heap sizes significantly, which helped the reports actually run, but after run a report the query service stays busy, which prevents a user from downloading the report to excel.

I chalk some of this slowness up to lack of experience with Dimensional report writing.

Is there a way that I can cache the reports overnight so my users do not feel the pain when running these various reports?

Thanks,
Grady

[froodyo]

This is the error I get when trying to run the reporting again:

XQE-CON-0007

   
         XQE error encountered: Your request could not be completed because the Query Service is busy. Try again later. If the problem persists, contact your system administrator.