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

 

News:

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

Main Menu

Distinct in Cognos Generated SQL

Started by mrcool, 31 Aug 2010 08:44:37 PM

Previous topic - Next topic

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.
Meep!

mrcool