COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: everlearner on 06 Jul 2012 02:46:12 AM

Title: left joins
Post by: everlearner on 06 Jul 2012 02:46:12 AM
Hi gurus,

please can any one explain how to create a left join between 2 tables in framework manager. i have little confusion at operator, cardinality in relationship definition window. please any one make me clear.

thanks in adv
Title: Re: left joins
Post by: CoolP on 06 Jul 2012 10:00:43 AM
Hi,


The best way to check the join conditions is to select both the query subjects after creating the join and rightclick them to test it. Then you will get options to look at the query created by FM. If you wanted something else, you can come, change the cardinality and then check.




Thanks
CP
Title: Re: left joins
Post by: Cognos_World on 16 Jul 2012 03:41:24 PM
The cardinality will look something like
1...1 on the left side and 0..n on the right side (in the drop down).
This will create a left outer join.

Also verify the Relationship Impact description.

The way to understand the relationship impact without the description is to see/read the cardinality from the opposite table for the 1st one and vice versa.

If 0..n is on the right hand side in the drop down, it reads outer join for the left side of the relationship.
Or, to put it in another way, we define the cardinality in the drop down for the each row of the other table.

Hope this helps!