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

Detecting duplicates to find errors

Started by tdoebler, 02 Jun 2009 12:56:58 PM

Previous topic - Next topic

tdoebler

We all know that you can eliminate duplicate rows in Cognos impromptu but I would like to find duplicate rows in a certain report since those would actually be errors.  Any ideas?  Thank you.

rlmarshall

if you have columns A,B,C,D,E,F,G
you  create calc column H = count('same') for A, B, C, D, E, F, G
and then create a summary filter where H > 1