--- title: Reporting performance using Concurrent Query Execution description: "Discover how to set-up Concurrent Query Execution to speed up the execution of the report.\n\"Tech Tip\" blog written by Principle Consultant, Andy Copeland" image: https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/chuttersnap-gts_Eh4g1lk-unsplash-scaled-1.jpg --- [Skip to content](https://resources.sempreanalytics.com/blogs/reporting-performance-using-concurrent-query-execution#main-content) - What We Do Design & Deliver [Enterprise Performance Management Accurately plan, forecast & budget to improve performance](https://www.sempreanalytics.com/enterprise-performance-management/) [Business Intelligence Answer key business questions using data](https://www.sempreanalytics.com/business-intelligence/) [Data Management Integrate, organise, secure and govern your data](https://www.sempreanalytics.com/data-management/) [Intelligent Automation Automate routine and repetitive tasks](https://www.sempreanalytics.com/intelligent-automation/) Optimise & Support [Managed Services The support you need, when you need it](https://www.sempreanalytics.com/managed-service/) [Training Services Increase the power of your data for decision making](https://www.sempreanalytics.com/sempre-analytics-training-courses/) Technologies [Anaplan](https://www.sempreanalytics.com/anaplan/) [Automation Anywhere](https://www.sempreanalytics.com/automation-anywhere/) [IBM](https://www.sempreanalytics.com/ibm-technologies/) [Informatica](https://www.sempreanalytics.com/informatica/) [Microsoft](https://www.sempreanalytics.com/microsoft/) - Who We Help Who We Help [Housebuilding & Construction Building scalable financial and operational planning solutions](https://www.sempreanalytics.com/housebuilding-construction/) [Retail Using data to improve customer experience and drive operational efficiency.](https://www.sempreanalytics.com/retail/) [Higher Education Enabling data driven decision making in Higher Education.](https://www.sempreanalytics.com/higher-education/) [Financial Services Enabling data driven decision making in Financial Services.](https://www.sempreanalytics.com/financial-services/) [Manufacturing Making effective and sustainable data driven decisions that improve business outcomes.](https://www.sempreanalytics.com/manufacturing-distribution/) Sector Insights [![claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1-200x200](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/menu/claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1-200x200.jpg?width=200&height=200&name=claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1-200x200.jpg)](https://www.sempreanalytics.com/clothing-retail-without-the-data-wheres-the-brand-resilience/) [Retail and Consumer Goods](https://www.sempreanalytics.com/category/industry-solutions/retail) [Clothing Retail: Without the Data, Where’s the Brand Resilience?](https://www.sempreanalytics.com/clothing-retail-without-the-data-wheres-the-brand-resilience/) [![iStock-1297914649-200x200](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/menu/iStock-1297914649-200x200.jpg?width=200&height=200&name=iStock-1297914649-200x200.jpg)](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) [Planning and Analytics](https://www.sempreanalytics.com/category/financial-planning) [Beyond IFRS 17: Data integration is a huge opportunity for insurance finance, not a compliance-related chore](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) [![jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1-200x200](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/menu/jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1-200x200.jpg?width=200&height=200&name=jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1-200x200.jpg)](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) [Planning and Analytics](https://www.sempreanalytics.com/fixing-remedial-costs-for-uk-housebuilders-data-integration-means-greater-business-resilience/) [Fixing remedial costs: for UK housebuilders, data integration means greater business resilience](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) - What We Are Resources & Support [Help Desk Accurately plan, forecast & budget to improve performance](https://www.sempreanalytics.com/help-desk/) [Our Blogs The latest Sempre expert insights and industry blogs](https://www.sempreanalytics.com/blogs/) [Our Events The latest Sempre events](https://www.sempreanalytics.com/events/) [Our Resources Dive into our latest content](https://www.sempreanalytics.com/resources/) Learn & Connect [Company Motivated by mission and purpose](https://www.sempreanalytics.com/company/) [Customer Stories Success stories from our clients](https://www.sempreanalytics.com/customer-stories/) [Our Approach Understand the things that make us different.](https://www.sempreanalytics.com/company/our-approach/) [Careers Latest career opportunities at Sempre Analytics](https://www.sempreanalytics.com/careers/) [Talk To Us Whatever challenge you face we’re here to help](https://www.sempreanalytics.com/contact/) Featured Insights [![Building Sales, Partnerships and People at Sempre](https://resources.sempreanalytics.com/hubfs/MicrosoftTeams-image%20(3).png)](https://resources.sempreanalytics.com/blogs/building-partnerships) [General](https://resources.sempreanalytics.com/blogs/tag/general) [Building Sales, Partnerships and People at Sempre](https://resources.sempreanalytics.com/blogs/building-partnerships) [![Funding Changes: What does it mean for Housing Associations and their Finance Teams](https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1.jpg)](https://resources.sempreanalytics.com/blogs/housing-associations-rent-convergence) [Anaplan](https://resources.sempreanalytics.com/blogs/tag/anaplan) [Funding Changes: What does it mean for Housing Associations and their Finance Teams](https://resources.sempreanalytics.com/blogs/housing-associations-rent-convergence) [![What’s New in Cognos 12.1.0 - The Story So Far…](https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/AdobeStock_889788354-scaled-1.jpg)](https://resources.sempreanalytics.com/blogs/cognos-12-1-0) [IBM Cognos Analytics](https://resources.sempreanalytics.com/blogs/tag/cognos-analytics) [What’s New in Cognos 12.1.0 - The Story So Far…](https://resources.sempreanalytics.com/blogs/cognos-12-1-0) - [Talk to us](https://www.sempreanalytics.com/contact/) [Talk to us](https://www.sempreanalytics.com/contact/) ![Reporting performance using Concurrent Query Execution](https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/chuttersnap-gts_Eh4g1lk-unsplash-scaled-1.jpg) by [Andy Copeland](https://resources.sempreanalytics.com/blogs/author/andy-copeland) ![Andy Copeland](https://resources.sempreanalytics.com/hubfs/Blog_authors/Andy%20Copeland.jpg) [mailto:andy.copeland@sempreanalytics.com](mailto:andy.copeland@sempreanalytics.com) [Data Management](https://resources.sempreanalytics.com/blogs/tag/data-management) # Reporting performance using Concurrent Query Execution In my last article called ‘How to work out how long queries in a Cognos Analytics report take to run’ we setup the logging to enable us to see exactly how long each query in a test report took to execute. In this article, we are going to setup Concurrently Query Execution to speed up the execution of the report. **Before we start, let's look at a list of pros and cons for this:** ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Andy-Concurrent-Query1.png?width=663&height=157&name=Andy-Concurrent-Query1.png) **In order to achieve this, we are going to do this to our report execution:** ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Andy-Concurrent-Query2.png?width=986&height=652&name=Andy-Concurrent-Query2.png) **In order to achieve this, we need to do the following:** 1. Set a series of advanced settings against the IBM Cognos ‘Batch Report’ and ‘Report’ services on each dispatcher. 2. Set the ‘Execution Method’ query hint appropriately in your report. 3. Execute the report. 4. Monitor the results by looking at the Dynamic Query Mode (XQE) logs. ### Setting Concurrent Query Execution settings This is arguably the most complex part of the whole process so I will try to explain this as simplistically as possible to aid understanding. The first setting is called **RSVP.CONCURRENTQUERY.MAXNUMHELPERSPERREPORT**, is the maximum number of query execution helpers for EACH report or batch report process. The default value for this setting is 0 which means concurrent query execution is DISABLED. If this setting remains at zero the maximum number of connections to the data source created by the report service is 16 (using all the other default out of the box settings). - For each Report Service Process - 2 x Low-Affinity Connections - 2 x High Affinity Connections If this setting is set to 2 the maximum number of connections to the data source created by the report service is 24 (using all the other default out of the box settings). **This is made up of:** - For each Report Service Process - 2 x Low-Affinity Connections - 2 x High-Affinity Connections - 2 x Query Execution Helpers The higher the setting for the number of helpers per process the more resources we have to process queries concurrently. The second setting is called **RSVP.CONCURRENTQUERY.NUMHELPERSPERREPORT,** specifies the maximum number of query execution helpers per REPORT. The default value is 1, however, without the number of helpers per-process setting having a value it is ignored. The third setting is called **RSVP.CONCURRENTQUERY.ENABLEDFORINTERACTIVEOUTPUT**. By default, any interactive report will not use concurrent query execution without this setting being specified as **‘true’**. An interactive report is one you are rendering as HTML and running on the screen. **Example:** Our report has 8 queries that can be executed concurrently. If the number of helpers per process AND the number of helpers per report are both set to 4, the report uses all available helpers and other reports will not run concurrently until that report has been completed. However, if we set the number of helpers per report to 2 this means that our report will execute and process the first queries whilst leaving some available capacity for a second report to also benefit from concurrent query execution. ***HINT:*** ***It is important to recognise that in an ideal world your number of helpers per-process value should always be higher than your number of helpers per report setting. It should be expected that a period of ‘playing’ around with these two settings is needed to achieve your best result for your reporting environment.*** ### Application of Advanced Settings In order to apply the settings you need to go into the Cognos Administration console and choose the System section and drill down to the ‘Batch Report Service’. When you edit the properties of the service, choose the ‘advanced settings’ option and enter the parameters in there as per the screenshot below. ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Concurrent-Query3.jpg?width=1024&height=374&name=Concurrent-Query3.jpg) ### Setting the Query ‘Execution Method’ In order to ‘enable’ a query to execute in concurrent mode, you need to work through each query in your report and change the query hint called ‘execution method’ as below. In our example, we have three queries and each will be set to concurrent mode. ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Concurrent-Query-Setting-Reduced.jpg?width=226&height=447&name=Concurrent-Query-Setting-Reduced.jpg) It is important to remember that you can only execute independent queries in this way (i.e. those not needing input from parent queries). ### Executing the report and analysing the results When you execute the report and check the xqe log files. You will see entries like the ones below. **Sequential:** ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Andy-Concurrent-Query5.png?width=872&height=250&name=Andy-Concurrent-Query5.png) **Concurrent:** ### ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Concurrent-Query6.jpg?width=1019&height=235&name=Concurrent-Query6.jpg) In the red box above you will see that all three queries are starting at almost the same time and their completions are around the same duration as when run in sequence. However, due to them running concurrently the overall execution time is dramatically reduced. This is exactly the desired effect that we are looking for. ### **Other considerations** It is important to note that some parts of Cognos reporting and particular types of queries **cannot** make use of the concurrent query technique. **Examples of this are:** 1. The resulting queries of any join or union queries. However, the source queries for these can be used. 2. Any prompt queries, you should use the ‘Use for parameter info’ query hint instead. 3. Any element of an Active Report that has queries supporting a ‘data deck’, ‘data list’ or similar data driven element. These will always been sequential regardless of the execution method setting. *It is also possible that the performance of a report can be worse after implementing these changes. The reasons this could happen would be an additional burden placed on your data source or your dispatcher settings are not optimally tuned. As stated earlier in this document, an exercise of tweaking settings and evaluating results ideally in a reasonably sized non-production environment is recommended.* ### ABC ## About the author **Andy Copeland** Experienced solutions architect who has many years experience in IBM Cognos Business Intelligence. In that time I have built up an excellent understanding of client requirements and a proven track record of delivering excellent Business Analytics and FPM Solutions that are reliable, scalable and deliver results. I also have a great deal of experience providing and managing an excellent customer service function in the Cognos arena. I also specialise in the system specification and design of integrated BI, Planning, Controller and TM1 environments and offer advice to other IBM Partners on the best practice approach to implementation. I am also a regular contributor to various IBM Cognos related forums and posting information on my blog to assist others who might be facing the same challenges. ## Related posts [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Data-Quality_small.jpg?width=352&name=Data-Quality_small.jpg) 1 August 2024](https://resources.sempreanalytics.com/blogs/9-reasons-why-upgrading-to-cognos-analytics-11-2-4-ltsr-is-a-smart-move) [IBM Cognos Analytics](https://resources.sempreanalytics.com/blogs/tag/cognos-analytics) ### [9 Reasons Why Upgrading to Cognos Analytics 11.2.4 LTSR is a Smart Move](https://resources.sempreanalytics.com/blogs/9-reasons-why-upgrading-to-cognos-analytics-11-2-4-ltsr-is-a-smart-move) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/fabio-633881-unsplash.jpg?width=352&name=fabio-633881-unsplash.jpg) 7 March 2024](https://resources.sempreanalytics.com/blogs/solving-data-integration-challenges) [Anaplan](https://resources.sempreanalytics.com/blogs/tag/anaplan) ### [Solving Data Integration Challenges  ](https://resources.sempreanalytics.com/blogs/solving-data-integration-challenges) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1.jpg?width=352&name=claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1.jpg) 11 June 2025](https://resources.sempreanalytics.com/blogs/housing-associations-rent-convergence) [Anaplan](https://resources.sempreanalytics.com/blogs/tag/anaplan) ### [Funding Changes: What does it mean for Housing Associations and their Finance Teams](https://resources.sempreanalytics.com/blogs/housing-associations-rent-convergence) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/rawpixel-594846-unsplash-1800x1246-1.jpg?width=352&name=rawpixel-594846-unsplash-1800x1246-1.jpg) 1 May 2024](https://resources.sempreanalytics.com/blogs/unlocking-financial-success-harnessing-the-power-of-ibm-planning-analytics) [Planning and Analytics](https://resources.sempreanalytics.com/blogs/tag/financial-planning) ### [Unlocking Financial Success: Harnessing the Power of IBM Planning Analytics](https://resources.sempreanalytics.com/blogs/unlocking-financial-success-harnessing-the-power-of-ibm-planning-analytics) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/emma-dau-n_4iTY1KmDE-unsplash.jpg?width=352&name=emma-dau-n_4iTY1KmDE-unsplash.jpg) 24 March 2020](https://resources.sempreanalytics.com/blogs/upskilling-key-to-effective-corporate-leadership) [Planning and Analytics](https://resources.sempreanalytics.com/blogs/tag/financial-planning) ### [Upskilling key to effective corporate leadership](https://resources.sempreanalytics.com/blogs/upskilling-key-to-effective-corporate-leadership) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/fabio-oyXis2kALVg-unsplash-1-1.jpg?width=352&name=fabio-oyXis2kALVg-unsplash-1-1.jpg) 25 February 2021](https://resources.sempreanalytics.com/blogs/the-connected-data-vision) [Data Management](https://resources.sempreanalytics.com/blogs/tag/data-management) ### [The Connected Data Vision](https://resources.sempreanalytics.com/blogs/the-connected-data-vision) ![anaplan-logo](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/anaplan-logo.svg) ![automation-anywhere-logo](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/automation-anywhere-logo.svg) ![ibm-logo-346x170](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/ibm-logo-346x170.png?width=346&height=170&name=ibm-logo-346x170.png) ![informatica-logo](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/informatica-logo.svg) ![microsoft-logo-346x170](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/microsoft-logo-346x170.jpg?width=346&height=170&name=microsoft-logo-346x170.jpg) Industry Solutions - [Finance, Insurance & Services](https://www.sempreanalytics.com/financial-services/) - [Housebuilding & Construction](https://www.sempreanalytics.com/housebuilding-construction/) - [Manufacturing & Distribution](https://www.sempreanalytics.com/manufacturing-distribution/) - [Retail & Consumer Goods](https://www.sempreanalytics.com/retail/) - [Higher Education](https://www.sempreanalytics.com/higher-education/) Technologies - [Anaplan](https://www.sempreanalytics.com/anaplan/) - [Automation Anywhere](https://www.sempreanalytics.com/automation-anywhere/) - [IBM Cognos Analytics](https://www.sempreanalytics.com/ibm-cognos-analytics/) - [IBM Controller](https://www.sempreanalytics.com/ibm-controller/) - [IBM Planning Analytics](https://www.sempreanalytics.com/ibm-planning-analytics/) - [Informatica](https://www.sempreanalytics.com/informatica/) - [Microsoft Data Platform](https://www.sempreanalytics.com/microsoft/) Learn & Connect - [Company](https://www.sempreanalytics.com/company/) - [Customer Stories](https://www.sempreanalytics.com/customer-stories/) - [Our Approach](https://www.sempreanalytics.com/company/our-approach/) - [Careers](https://www.sempreanalytics.com/careers/) - [Resources](https://www.sempreanalytics.com/resources) - [Talk To Us](https://www.sempreanalytics.com/contact/) - [Helpdesk ![extension](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/external.svg)](https://www.sempreanalytics.com/help-desk/) [Talk to us](https://www.sempreanalytics.com/contact/) - - - [Privacy Policy](https://www.sempreanalytics.com/privacy/) - [Cookie Policy](https://www.sempreanalytics.com/cookie-policy/) - [Web Design by Fhoke](https://www.fhoke.com/) © 2026 Sempre Analytics ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Andy Copeland", "url" : "https://resources.sempreanalytics.com/blogs/author/andy-copeland" }, "dateModified" : "2025-07-11T08:06:55.958Z", "datePublished" : "2020-06-02T10:09:38.000Z", "headline" : "Reporting performance using Concurrent Query Execution", "image" : [ "https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/chuttersnap-gts_Eh4g1lk-unsplash-scaled-1.jpg" ], "mainEntityOfPage" : { "@id" : "https://resources.sempreanalytics.com/blogs/reporting-performance-using-concurrent-query-execution", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://resources.sempreanalytics.com/hubfs/Sempre%20-%20logo%20-%20smaller.jpg" }, "name" : "sempre analytics" } } ```