COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 03 May 2014 09:05:46 PM

Title: Report Autogroup and Summarize Causes Slowness in the Query in Report Author 10.
Post by: gosoccer on 03 May 2014 09:05:46 PM

Turning Off Auto Group and Summary in Query Property (Runnning to slow) in Report Author 10.1.2

Posted by gocognos



The report as you have a snapshot has five columns,
Action || Success || Success% || Failure || Failure % || Total

Update Email || 5 || 100% || 0 || 0% || 5

SO THE AUTOGROUP AND SUMMARY SETUP ON THE QUERY causing a big slowness on the report. If I say NO to the Autogroup and Summary, it runs much faster but I loose all the aggregation on counts, percentage and totals.

If some one could just give me hint or an example to follow for setting up calculations and Function Aggregation correctly for each column, so I can get the same result, I would greatly greatly appreciate it.

Thank you so much for your time.