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
Make Outer join on Query 2