Sorry for the unclear title, I ran out of space. I am working on a report that has many joins. I need to replace many of those joined queries with a new (fixed) query. When I remove one of the two joined queries and add the new (fixed) query, the "Join Relationships" 'wizard' disappears and is instead replaced by the Join Expression window. The only way to get the Join Relationships window back is to recreate the query from scratch. I find this to be an extremely inefficient workflow.
1.) Why does this happen?
2.) Can I get the Join Relationships window back after removing and replacing a query in a join, as opposed to using the Join Expression window?
3.) How does the absence of the Cardinality option the Join Expression window affect the logical join criteria used?
Thanks all
(http://i1305.photobucket.com/albums/s557/PSRNHME/Join%20Relationships%20window%20unavailable%20after%20removing%20joined%20query_zpsvpipnpkn.jpg) (http://s1305.photobucket.com/user/PSRNHME/media/Join%20Relationships%20window%20unavailable%20after%20removing%20joined%20query_zpsvpipnpkn.jpg.html)
Hi psr,
1) if you look closely into the expression editor, the join expression still references the query that you removed from the join. Cognos cannot find those fields in the join and thus cannot setup the UI
2) yup. Just edit the expression to something that cognos can resolve (i.e., reference the new query instead), hit ok, and double click the join again
3) very interesting question, which I've never thought about. no idea here.
Question 3:
Left side controls inner/outer joins
Right side basically controls fact detection process when SQL gets generated (see link below for more details)
When you have invalid or complex relationships, the GUI goes away, and they syntax in the box is used for the join (which will throw errors if it's not valid)...
https://www.ibm.com/support/knowledgecenter/SSWGNW_10.1.0/com.ibm.swg.im.cognos.ug_fm.10.1.0.doc/ug_fm_id4278cardinality.html