COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: everlearner on 09 Jul 2012 06:20:22 AM

Title: cardinality???
Post by: everlearner on 09 Jul 2012 06:20:22 AM
Hi all,

i have two tables,
lets suppose A,B.
in table A the column has values like 110,111,112..etc
in Tbale B the column has values like 110,110,110,111,112..etc

am getting confusion at cardinality when creating relationship in framework manager.

i have to create left outer join for this.

can any one tell me the which cardinality i should take for table A and table B?


thanks in adv
Title: Re: cardinality???
Post by: blom0344 on 09 Jul 2012 06:42:26 AM
Cardinality is about 2 things:

1. Deciding whether a normal join suffices or an outer join is required
2. Deciding if you want subjects to behave like dimension vs fact

When Table A is joined to Table B and you need data returned from table A regardless whether key value exists in table B then you set cardinality as:

1:1 <--> 1:0    or 1:n <--> 1.0

When you set the cardinality Cognos explains the consequence directly below the cardinality setting

edit:

Please keep your posts on the same subject together..
Title: Re: cardinality???
Post by: everlearner on 09 Jul 2012 07:16:26 AM
thanks blom for the explanation.

another doubt, i tried to get right outer join. i tried in all possible ways. but i didt get. for suppose to get right outer join what shud i so?
Title: Re: cardinality???
Post by: MFGF on 09 Jul 2012 10:05:01 AM
Put the 'n' at the other side of the relationship from your original left outer join. A Right Outer Join simply has the "many" cardinality on the opposite side to a left outer join.

Regards,

MF.