Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Self Join using two query subjects. Cognos 8

Status
Not open for further replies.

handpass

Programmer
Oct 13, 2006
10
US
Hi,
I have two query subjects that have the exact same table entries in each of them. For one of the entries I have a different filter value applied for each query.

QS1
BatchId
Parameter (Filter:parameter=Volume)

QS2
BatchId
Parameter (Filter:parameter=Height)

I now want to join these two query subjects together so that I can get a combination of the two results.

QS1 QS2
BatchId(1..1)_______(1..1)BatchId
Paramter Paramter


When I test this I don't get any results returned.
It's as if the filter value in each of the query subjects is being joined with an 'AND', and because the filter is on the same entry in both query subjects it means that it can't be two different values at the same time. I am modelling all of this in Framework manager.

Regards.
 
Hi,

Provided the data supports it, this should work as you expect. If you test the query subjects individually, can you confirm that you are getting the common BatchID values returned in each?

MF.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top