cardinality???

[everlearner]

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

[blom0344]

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..

[everlearner]

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?

[MFGF]

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.