Steps to setup concurrent query execution

If you need to improve performance by executing concurrent queries at the same time follow the below steps. Be aware that this is environment setup so it will affect all Cognos applications.
 
1- Go to Cognos Adminstration -> System 
2-  Select the System and click on the “triangle shape” icon
3-  Select Set Properties
 

      4- Select Settings Tab

5- On the Advanced settings, select Edit

6- Add the following parameters:

RSVP.CONCURRENTQUERY.ENABLEDFORINTERACTIVEOUTPUT = true

RSVP.CONCURRENTQUERY.NUMHELPERSPERPROCESS = 16

RSVP.CONCURRENTQUERY.MAXNUMHELPERSPERREPORT = 4

7- Scroll down and click OK

8- Now in Cognos Administration -> Settings –System click Refresh 
9- Expand the Advanced settings sections to the parameters you just added.

10- In Report Studio, Go to Query Explorer 
11- Select the first query 
12- In the properties section, change “Execution Method” to Concurrent

13- Repeat the previous step and change all queries to have “Execution Method” with the value Concurrent. 

14- Run the report.