Print Page - I get duplicates on joining stored procedure based query to a normal query

Title: I get duplicates on joining stored procedure based query to a normal query
Post by: sameena on 09 Dec 2011 04:42:10 AM

Hi,
I created a report by joining a stored procedure to a normal query. I have joined them using 1:1 relationship. But my output displays a couple of duplicates and a few rows are missing too. Please suggest..

Thanks,
Sameena

Title: Re: I get duplicates on joining stored procedure based query to a normal query
Post by: blom0344 on 09 Dec 2011 04:00:07 PM

Setting the cardinality to 1:1 has no effect whatever in production of the output. It is strictly a way for Cognos to determine a fact in the relation. The join strategy (database) determines whether duplates are returned. The missing rows may be the result of not using an outer join.
Determine which side is the master and apply outer join.

Title: Re: I get duplicates on joining stored procedure based query to a normal query
Post by: sameena on 12 Dec 2011 02:55:57 AM

Thanks blom!! I used outer join and see no duplicates now.

Sameena

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sameena on 09 Dec 2011 04:42:10 AM