--- title: Cognos Analytics Report - How long should they take to run? description: Identify what needs to change to improve report performance. Andy Copeland, Principle Consultant image: https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/christopher-gower-m_HRfLhgABo-unsplash-scaled-1.jpg --- [Skip to content](https://resources.sempreanalytics.com/blogs/cognos-analytics-report-how-long-should-they-take-to-run#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/) ![Cognos Analytics Report - How long should they take to run?](https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/christopher-gower-m_HRfLhgABo-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) # Cognos Analytics Report - How long should they take to run? **How to work out how long queries in a Cognos Analytics report take to run** One question I have been asked quite a few times is ‘I have a report that is taking a long time to run and I don’t know why?’. So, how I approach this is as follows: 1. Identify which queries are my slow running queries? 2. Look at optimising them by running them concurrently and therefore reduce the report execution time. 3. Look at the SQL and use database tools to identify performance improvements. By taking this approach, I have successfully reduced execution times of reports from an hour to literally 30 seconds. This article looks at the first of these steps on how to identify those slowly executing queries. **Setup:** 1. Locate the file **xqe.diagnosticlogging.xml** in the configuration directory of your Cognos Analytics (or Cognos 10 BI) installation. 2. Open the file using a text editor and look for a section called ‘’. This contains a number of lines called Event Groups. 3. Go to the bottom of the list of event groups and add a new one with the text ‘’. The screenshot below shows what the finished line looks like. ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/CA_QueryService_SQL-Image.jpg?width=984&height=730&name=CA_QueryService_SQL-Image.jpg) 4. Finally, restart the IBM Cognos service that is running on your server. Please remember that you must make this change for every server in your environment that has report dispatching capabilities. Once restarted every query execution will be logged. **Testing:** In order to test the new level of logging, I have created a report using the relational samples. The report contains three frames, a list, a crosstab, and a word cloud visualisation. Each frame is supported by a single query. Below is the design of my report and the list of queries that support it. ![](https://static.hsstatic.net/BlogImporterAssetsUI/ex/missing-image.png)![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/CA_Relational-Samples-Image_2.jpg?width=802&height=595&name=CA_Relational-Samples-Image_2.jpg) When I execute the report, the report successfully completes, and I want to review the information captured. In order to do this, I need to navigate to the dispatching server that the report was executed from and look for ‘xqelog’ log files. These files are timestamped and grow to be 10mb in size. They reside in the **\\logs\\xqe** folder on each dispatcher. When you have identified the XQE log file, open it and you will see something similar to the screenshot below in terms of the format. ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/XQE-Log-File-image.jpg?width=1380&height=714&name=XQE-Log-File-image.jpg) This is the actual log from execution of the report I created. As you will see we have six lines of information, three START lines, and three END lines. These are the actual times that the Report Dispatcher submitted the queries and received the results back. Each query has its own thread and as you can see they are in sequence. Outside the view of the screenshot is the actual SQL statement submitted which you can cut and paste into your favorite query analyser tool such as SQL Server Management Studio. **Evaluation and Improvement:** The kind of information I am looking for is the ‘duration’ which is in thousandths of a second. I often list the queries in a spreadsheet and capture the durations so I can ascertain the split between a reports queries executing and the time the dispatcher then uses to render the actual report output (xlsx, pdf, html etc) using the Presentation Service. Taking my example report results I can see that: 1.      Query 1 took 1.502 seconds to complete 2.     Query 2 took 0.521 seconds to complete 3.     Query 3 took 1.811 seconds to complete 4.     They all ran in sequence and used a thread each. The report took a total of 5.1 seconds to render as HTML onto the screen (stats is taken from my Cognos Audit database **COGIPF\_RUNREPORT** table) therefore my rough split of a query execution to the report rendering is 3.83 seconds query execution and 1.27 seconds HTML generation and display. Once I have this information, I consider the following: 1.      Ways to reduce the report execution duration using concurrent query execution. 2.     Ways to improve query performance. 3.     Ways to reduce the number of queries in order to use queries for more than one frame. *In the next article, I will show you how to set-up concurrent query execution and see the impact it has on our test report.* ## 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/artem-beliaikin-jt9Lnsmq-3Y-unsplash-scaled-1.jpg?width=352&name=artem-beliaikin-jt9Lnsmq-3Y-unsplash-scaled-1.jpg) 15 December 2020](https://resources.sempreanalytics.com/blogs/financial-resilience-in-retail) [Anaplan](https://resources.sempreanalytics.com/blogs/tag/anaplan) ### [Which Retailers are proving to have Financial Resilience?](https://resources.sempreanalytics.com/blogs/financial-resilience-in-retail) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/adult-brainstorming-business-2000pxl.jpg?width=352&name=adult-brainstorming-business-2000pxl.jpg) 13 March 2024](https://resources.sempreanalytics.com/blogs/empowering-finance-leaders-transforming-finance-reclaiming-weekends-with-philip-bichard) [Planning and Analytics](https://resources.sempreanalytics.com/blogs/tag/financial-planning) ### [Empowering Finance Leaders: Transforming Finance & Reclaiming Weekends with Philip Bichard](https://resources.sempreanalytics.com/blogs/empowering-finance-leaders-transforming-finance-reclaiming-weekends-with-philip-bichard) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/chuttersnap-gts_Eh4g1lk-unsplash-scaled-1.jpg?width=352&name=chuttersnap-gts_Eh4g1lk-unsplash-scaled-1.jpg) 2 June 2020](https://resources.sempreanalytics.com/blogs/reporting-performance-using-concurrent-query-execution) [Data Management](https://resources.sempreanalytics.com/blogs/tag/data-management) ### [Reporting performance using Concurrent Query Execution](https://resources.sempreanalytics.com/blogs/reporting-performance-using-concurrent-query-execution) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1.jpg?width=352&name=jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1.jpg) 9 June 2022](https://resources.sempreanalytics.com/blogs/fixing-remedial-costs-for-uk-housebuilders-data-integration-means-greater-business-resilience) [Planning and Analytics](https://resources.sempreanalytics.com/blogs/tag/financial-planning) ### [Fixing remedial costs: for UK housebuilders, data integration means greater business resilience](https://resources.sempreanalytics.com/blogs/fixing-remedial-costs-for-uk-housebuilders-data-integration-means-greater-business-resilience) [![](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/AdobeStock_640041180.jpg?width=352&name=AdobeStock_640041180.jpg) 5 August 2024](https://resources.sempreanalytics.com/blogs/whats-exciting-us-about-the-new-release-of-cognos-12) [Data Management](https://resources.sempreanalytics.com/blogs/tag/data-management) ### [V12 was the last major release of IBM Cognos Analytics.](https://resources.sempreanalytics.com/blogs/whats-exciting-us-about-the-new-release-of-cognos-12) ![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:07:51.678Z", "datePublished" : "2020-05-11T10:06:07.000Z", "headline" : "Cognos Analytics Report - How long should they take to run?", "image" : [ "https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/christopher-gower-m_HRfLhgABo-unsplash-scaled-1.jpg" ], "mainEntityOfPage" : { "@id" : "https://resources.sempreanalytics.com/blogs/cognos-analytics-report-how-long-should-they-take-to-run", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://resources.sempreanalytics.com/hubfs/Sempre%20-%20logo%20-%20smaller.jpg" }, "name" : "sempre analytics" } } ```