COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Bonediggler on 30 Jul 2014 10:29:10 AM

Title: Disable a Query
Post by: Bonediggler on 30 Jul 2014 10:29:10 AM
Experts -

I have a multi-page report based off several queries (it needs to be simplified but no time for that now).  I am in testing phase and would like to run the report with small data sets - only one or two queries at a time, not the whole report.

Is this possible?

Thank you!
Title: Re: Disable a Query
Post by: Lynn on 30 Jul 2014 11:24:39 AM
You can run one page at a time by going to the page explorer and then right-clicking on the desired page. You can remove the layout container for any queries you don't want to execute, and then put them back in later. You can also set a render variable on any container so that it won't render which will cause the query not to execute.
Title: Re: Disable a Query
Post by: cognostechie on 30 Jul 2014 11:30:15 AM
You can also go to the query explorer, select one query and from the 'Run' menu, select 'View Tabular Data'.