If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multi fact queries - outer joins

Started by nsd, 20 May 2010 08:47:34 PM

Previous topic - Next topic

nsd

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.