COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: tdoebler on 02 Jun 2009 12:56:58 PM

Title: Detecting duplicates to find errors
Post by: tdoebler on 02 Jun 2009 12:56:58 PM
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.
Title: Re: Detecting duplicates to find errors
Post by: rlmarshall on 10 Jul 2009 03:43:41 PM
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