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

Joins. Please help!

Started by Kazz, 06 Apr 2008 06:36:48 PM

Previous topic - Next topic

Kazz

Hello,
I am having trouble with joins on Cognos 8. Basically I have 2 queries, query one has a list of week ending dates while query two has a list of people and sales measures. My aim is to include all week ending dates from query 2 and apply it to everyone in query 1. My aim is for the final result to include all weeks; even weeks when the sales person made no sales. So far, my report only returns weeks when the sales person made sales. Please help!
Cheers,
Kaz

Gopinath

Make Outer join on Query 2