Print Page - SQL Query Join - Minor problem encounted

Title: SQL Query Join - Minor problem encounted
Post by: keating101 on 19 Apr 2013 12:16:25 AM

Hello All,

I am quite new to cognos report studio, so please bear with me.

I have a designed a report that lists all the transactions for a department centre. Some of the transactions are store issues from an internal warehouse. The only information I can get in this report is the product id number, not the actual description of the product.

So i have created an SQL join (joined by common link of product id number) to look up the product id description.

The sql join is working fine, and the product description is been shown correctly.

However, all the other transactions in the department (ie salary transactions) are now not been displayed ?

I hope this makes sense.

I would appreciate any one's feedback on how to overcome this problem.

thanks in advance
Shaun

Title: Re: SQL Query Join - Minor problem encounted
Post by: blom0344 on 19 Apr 2013 03:09:52 AM

You may need to define a left outer to avoid losing data. You can set this in the join definition as 1--0 or N--0 cardinality

Title: Re: SQL Query Join - Minor problem encounted
Post by: keating101 on 21 Apr 2013 11:08:35 PM

Solution successful - thankyou

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: keating101 on 19 Apr 2013 12:16:25 AM