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

Cognos is wrongly aggregating duplicated lines

Started by ArnaudStephanHTH, 10 Sep 2019 04:52:21 AM

Previous topic - Next topic

ArnaudStephanHTH

Hi everyone,

I'm trying to migrate a report from an existing solution to Cognos. Lucky for me, the existing solution provides us with the SQL used to generate the report, so for those reports we just have to copy paste the SQL into Cognos, and voilĂ . The report is a simple list regarding billing, nothing fancy.

For this specific case we are having a problem, as the Cognos report has less lines than the original one. I have pinpointed the problem to duplicated lines that Cognos aggregates, even when I specify that there should be no aggregation for every column of the report. I went through the properties of each column and selected "None" for both the aggregation options.

I have attached a picture of the problem. On top is the 2 lines generated in Cognos, on the bottom is the 4 lines I get if I execute the SQL directly on the database.

Any idea on what I could do to fix this ?

ashley

Try turning off the auto group and summarise property in the query properties.

ArnaudStephanHTH

I found the solution.

In the properties of all the data items, I had to select Detail > No.