If you are unable to create a new account, please email support@bspsoftware.com



MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Auto Group & Smmerize option in QS!

Started by PRIT AMRIT, 05 Dec 2012 05:50:29 AM

Previous topic - Next topic


Hello Guru's,

Pls find attached doc for a better understanding.

Is there a way to set 'Auto Group & Summerize'=NO in Query studio?

As you can see in the attached document, I would like to have the QS report output same as RS output. Is it possible?




Yes, go to the "Run Report" menu and select "Advanced Options..."

Under Query Options un-check the box next to "Automatically summarize detail values, suppressing duplicates"


Thanks Lynn.

It didn't help resloving my issue though. The issue is, I have a very complex FM design where I have a lot of shared DIM joined with FACT tables. For some specific reports, based on the underlying design Cognos writing Individual querie's and stitching it locally with FULL OUTER join. Which absolutely fine and the data is correct too.

But as you can see the attached dcument in my previous post, some column in the reports the value is not repeating for all the rows,where as the business want this to be repeated.