Fine tune Cognos reports?

[czaarsvk]

1.) What are the steps to fine tune a slow running cognos reporT?  Is there a way to monitor report performance?

2.) Can you connect to SSAS cubes from report studio?

Thanks in advance.

[navissar]

1. Performance enhancement for a report is just as much art as it is science. Yet, here are some general guidelines:
For relational reports, look at the SQL. Really read it, see that it makes sense. Run the SQL in the database. If the SQL takes a long time to run, then the problem isn't that the report is slow, but rather that the query is slow to return. If that's the case, you're venturing into the world of SQL optimization. Look at the execution plan, figure out what takes so much time. Get a DBA to help.
If the query comes back at a reasonable time but the report still takes ages, it's time to examine the report. Are you using charts/crosstabs over relational? If so, Cognos will create a small cube for them on server. Does the Cognos server have enough resources?
Are you using master-detail relationships? These can slow down a report to a standstill.
How many rows per page are you fetching? try lowering that.
Is there more than one query running?
And so on...

Over dimensional, also make sure you're not using stuff like detail filters and case statements and the likes, things that do not exist in MDX.

2. You can create a datasource for SSAS, publish the desired cube from Framework Manager, and have it accessible in RS, yes.