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.