Author Topic: Auto Group & Smmerize option in QS!  (Read 2287 times)

Offline Prit

  • Statesman
  • ******
  • Join Date: Oct 2010
  • Posts: 450
  • Forum Citizenship: +16/-1
  • Sharing Knowledge and Ideas
Auto Group & Smmerize option in QS!
« on: 05 Dec 2012 05:50:29 am »
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

Offline Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,610
  • Forum Citizenship: +335/-1
Re: Auto Group & Smmerize option in QS!
« Reply #1 on: 10 Dec 2012 02:32:34 pm »
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"

Offline Prit

  • Statesman
  • ******
  • Join Date: Oct 2010
  • Posts: 450
  • Forum Citizenship: +16/-1
  • Sharing Knowledge and Ideas
Re: Auto Group & Smmerize option in QS!
« Reply #2 on: 12 Dec 2012 04:44:19 am »
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.

 


       
Twittear