Print Page - Help me with this Report Output

Title: Help me with this Report Output
Post by: richiearora on 27 Feb 2011 02:53:08 AM

Hi All,

I have created a OLTP report.

I have a Union Query on 2 tables which Fetch Data for my report.

When i Run the Report in Cognos it Shows me 12 records.

However in source i have only 6 Records.

Account Number   Scenario Id   Scenario Long Description   Process Status
212   1   ww   Yet to be Processed
222   1   ww   Yet to be Processed
345   1   ww   Yet to be Processed
500   2   ssd   Yet to be Processed
650   2   ssd   Yet to be Processed
6501   2   ssd   Yet to be Processed
      ww   Yet to be Processed
      ww   Yet to be Processed
      ww   Yet to be Processed
      ssd   Yet to be Processed
      ssd   Yet to be Processed
      ssd   Yet to be Processed

Please note the output, The rows with Empty Account Number and Scenario ID Data is duplicate.

This records are not there in my DB. I have queried them and have seen that.

Please help what am i doing wrong?

Regards,
Richie

Title: Re: Help me with this Report Output
Post by: PRIT AMRIT on 27 Feb 2011 08:54:54 PM

Not sure though how you have set your UNION Query data items, In your final query, change the 'Aggregation' to TOTAL for Account Number and Scenario ID and see if it resolves your issue?

Title: Re: Help me with this Report Output
Post by: blom0344 on 28 Feb 2011 02:21:18 AM

Simply add a filter to remove any combinations with null values for accountnumber. Your model will probably have outer joins (most OLTP models will have) and you end up with unwanted combinations due to this..

Title: Re: Help me with this Report Output
Post by: richiearora on 28 Feb 2011 03:15:28 AM

Hi Blossom,

Thansk for reply, I have a inner Join in my Model.

its not a outer join.

Any other insight?

Regards,
richie

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: richiearora on 27 Feb 2011 02:53:08 AM