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

Eliminate Duplicate Records

Started by ComplexQry, 14 Dec 2009 01:54:40 PM

Previous topic - Next topic

ComplexQry

I liked that checkbox in Impromptu...  Whats the closest thing to it in Report Studio?

blom0344

Cognos adds a distinct to the SQL if no query item has an aggregate set. So, if you only fetch identifiers and attributes you should have a distinct set by default. If not, adding a distinct is pretty useless..