COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: nsd on 20 May 2010 08:47:34 PM

Title: Multi fact queries - outer joins
Post by: nsd on 20 May 2010 08:47:34 PM
Hi

I have a scenario where I need to get conversion rates from multi facts from sale transactions and people count for stores. Not all stores have people count reading so will only need to report on those stores. However, the query is returning all stores because of full outer joins when using stitch queries. Simply - how do I get stitch queries to perform an inner join?

One way I can think of solving is have another query taking the result set from the first query and eliminate those unwanted locations. When I do that I can view the report in HTML but unable to get to view in PDF (runs forever). I am not sure why this is so!

Another solutions via IBM:

http://www.ibm.com/developerworks/data/library/cognos/page472.html

with regards to this but its not ideal as it requires setting up one set of joins for stitch queries and one set for combinations and I am not sure users will understand which one to use.. and may lead to wrong results.

Thanks.