Print Page - How to get sql query from the report , which has already been run

Title: How to get sql query from the report , which has already been run
Post by: inu on 31 Mar 2015 03:08:43 PM

HI Forum member,

Is it possible to get the sql query from the running report or already has been run the same, so that i can take that query and execute against the database for testing purpose...

With Regards
Inam

Title: Re: How to get sql query from the report , which has already been run
Post by: BigChris on 01 Apr 2015 02:26:01 AM

You can't get the SQL from the output, but you can get the SQL from the query. In Report Studio, click on Tools in the menu bar and go to Show Generated SQL/MDX.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 31 Mar 2015 03:08:43 PM