Is there a way to see the query being created to render a report?

[LR]

Hi,
I wanted to ensure that my report doesn't suffer due to performance issues when it goes live.
Is there a way where we can check the generated query to render the report.

[blom0344]

You can check the SQL (both Cognos / Native) that Cognos proposes to use (will use) :

'Show generated SQL/MDX' from the menu --> Tools when you select a query.

The tricky thing is , that the actual query executed on the database may differ from the proposition, but it is a good starter for now..

[bdbits]

In addition to the menu item mentioned, you could always have your DBAs run a trace to capture the SQL that is being sent over.