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

SOLVED: How to pull duplicate data only in Reports Studio

Started by Web2CRM, 02 Jul 2013 11:53:59 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Web2CRM

02 Jul 2013 11:53:59 PM Last Edit: 03 Jul 2013 01:22:26 AM by Web2CRM
I have a  list report created which is supposed to pull records with duplicate data only, but it seems not to work as expected because it is also pulling unique records.  Anyone here can help me handle such situation?  Thanks in advance!!!!

CognosPaul

#1
03 Jul 2013 01:06:10 AM
Does your data contain a key you can use to find the duplicate data? Create a new data item with the expression 1, with the aggregate function sum. Drag that into the summary filter, scope set to your key. [Data item]> 1

Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite