Author Topic: Cognos is wrongly aggregating duplicated lines  (Read 86 times)

Offline ArnaudStephanHTH

  • Associate
  • **
  • Join Date: Sep 2019
  • Posts: 2
  • Forum Citizenship: +0/-0
Cognos is wrongly aggregating duplicated lines
« on: 10 Sep 2019 04:52:21 am »
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 ?

Online ashley

  • Full Member
  • ***
  • Join Date: Feb 2018
  • Posts: 11
  • Forum Citizenship: +1/-0
Re: Cognos is wrongly aggregating duplicated lines
« Reply #1 on: 10 Sep 2019 06:15:28 am »
Try turning off the auto group and summarise property in the query properties.

Offline ArnaudStephanHTH

  • Associate
  • **
  • Join Date: Sep 2019
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Cognos is wrongly aggregating duplicated lines
« Reply #2 on: 10 Sep 2019 07:29:26 am »
I found the solution.

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

 



       
Twittear