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
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.