Author Topic: How to make active report more efficient in Cognos 11.1?  (Read 170 times)

Offline pacificbeavs

  • Full Member
  • ***
  • Join Date: Jan 2018
  • Posts: 47
  • Forum Citizenship: +0/-0
I have some active reports that are running slowly (20 minutes to an hour).  They are about 3-5MB in size, and look through 5 or 6 million records, which are then aggregated in visualization form.

A couple of the reports contain joined queries (two queries joined together to make a third query).  I realize this is very broad, but are there any general recommendations to improve report performance?  Perhaps any specific query settings to toggle within Cognos?

Thanks!

Offline pacificbeavs

  • Full Member
  • ***
  • Join Date: Jan 2018
  • Posts: 47
  • Forum Citizenship: +0/-0
Re: How to make active report more efficient in Cognos 11.1?
« Reply #1 on: 15 May 2019 01:29:16 pm »
Any efficiency tips??

I discovered that turning off the auto-group and summarize function results in better performance, however I still need to play around to see how that impacts the data I'm displaying, and when to toggle it on/off.

Offline pacificbeavs

  • Full Member
  • ***
  • Join Date: Jan 2018
  • Posts: 47
  • Forum Citizenship: +0/-0
Re: How to make active report more efficient in Cognos 11.1?
« Reply #2 on: 22 May 2019 01:10:56 pm »
Update - The particular report I'm interested in improving runs 5 minutes in our Test environment, and an hour in our production environment.  We re-booted the production server, and that same report has different behavior... when filtered for 1 year of data it runs in 5 minutes in production, but when filtered for 2 or 3 years it takes 1.5 hours.  Why would that be?  Any thoughts?

 



       
Twittear