Help me with this Report Output

[richiearora]

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

[PRIT AMRIT]

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?

[blom0344]

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..

[richiearora]

Hi Blossom,

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

its not a outer join.

Any other insight?

Regards,
richie