Auto Group & Smmerize option in QS!

[PRIT AMRIT]

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?

Thanks

Regards,
Prit

[Lynn]

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"

[PRIT AMRIT]

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.