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

Title: Is there a way to see the query being created to render a report?
Post by: LR on 01 Jun 2012 05:12:27 AM

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.

Title: Re: Is there a way to see the query being created to render a report?
Post by: blom0344 on 01 Jun 2012 07:20:35 AM

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

Title: Re: Is there a way to see the query being created to render a report?
Post by: bdbits on 01 Jun 2012 10:17:05 AM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: LR on 01 Jun 2012 05:12:27 AM