Distinct in Cognos Generated SQL

[mrcool]

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

[MFGF]

See Ties's reply to your other post here

MF.

[mrcool]

Thank You MF...