Print Page - Distinct in Cognos Generated SQL

Title: Distinct in Cognos Generated SQL
Post by: mrcool on 31 Aug 2010 08:44:37 PM

Hi All,

I am facing a serious issue with the cognos generated SQL in Analysis Studio.

I dragged 1 dimension to row and 1 dimension to column with 'Get Data Later' enabled. When I checked the SQL in the back end it was having distinct instead of group. My data volume is too huge because of which it is taking so much because of distinct. How to force cognos to write group by?

Any help would be highly appreciated.

Cheers,
Mrcool

Title: Re: Distinct in Cognos Generated SQL
Post by: MFGF on 01 Sep 2010 08:55:58 AM

See Ties's reply to your other post here (http://www.cognoise.com/community/index.php/topic,10754.0.html)

MF.

Title: Re: Distinct in Cognos Generated SQL
Post by: mrcool on 02 Sep 2010 11:19:35 PM

Thank You MF...

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: mrcool on 31 Aug 2010 08:44:37 PM