Filter the data in one query based on the result from another query in Cognos

Question

I need to use a column data obtained in a query in Q1 as a filter in Q2. Is there a way? Can anyone please suggest? I'm a beginner.

PS: Need to pull the report based on the country. I have 3 columns in Q1 ---> User Name, User ID, User email 3 columns in Q2--> User ID, user location and user country A join condition between Q1.userID and Q2.userID works. but I need to create a report that pulls the users details based on the country I select.

Answer 1

It would be best to do this via a proper model instead of modelling in the report. That being said, in a pinch, you could set the allow cross join query hint on both queries and create a filter similar to:

[Query1].[UserID]=[Query2].[UserID] and [Query2].[Country]=?p_Country?