COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Abbes008 on 03 Jun 2016 09:21:25 AM

Title: Bad performance when report export to Excel (2007)
Post by: Abbes008 on 03 Jun 2016 09:21:25 AM
I have made report with some columns and filter based on period. When I run the report in CSV format it takes 5 minutes. When I run this same query with 2 grouping columns and one subtotal and total, the export goes to Excel 2007 it takes about 1 hour. I tried a lot of parameters of the query but nothing helps. Have someone ideas?