Slowly Running Reports using Framework manager package

[Peewee71]

Hi,
I have some reports in report studio that are built using a framework manager package. What is the standard way to work out where the bottleneck is?

If the report uses SQL rather than a package I could run the sql in an editor such as TOAD and work out where the bottleneck is, but how would I do the same with a framework manager package based report.

Apologies if this is really obvious to some of you, i'm new to the framework manager side of things....
Thanks in Advance..

[bdbits]

I am assuming this is a relational package, though you did not say.

It is not necessarily in the SQL. Many things can affect execution time. But, the quality of the FM model certainly can have a substantial effect on how the SQL is generated. So, you may need to discuss what you find with the modeler.

Within Report Studio, choose menu item Tools > Show Generated SQL / MDX to see the report SQL.  If you have a non-relational model, it's not going to be straight SQL. The other thing you can do is have the DBA capture the SQL on the database side when the report is submitted. There are also tracing facilities within the Cognos Server an admin can enable that can give very detailed information on the report generation process. But that's a bit more in-depth so see if you can grab the SQL and eliminate that as a problem first.