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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kvenkata
-
Forcing subquery in main query filter as optional even when data exists
where ( PROJ = (SELECT NAME FROM SOURCE.MGMT WHERE NUM = '<P31>' and BUS_PARTNER = '<BP>') ) To do this in cognos: I have taken Query 1:SELECT NAME FROM SOURCE.MGMT WHERE NUM = '<P31>' and PARTNER = '<BP>' Filter usage :option for NUM='<P31>' and Required for PARTNER='<BP>' Now in Query 2...- kvenkata
- Thread
- Replies: 0
- Forum: Cognos solutions
