Good explanation on cardinaly and how joins work in Framework manager-Cognos

I came across this good explanation and wanted to share:


It's strange but this is how to understand the Denotation Cognos Uses

[T:O] ? {T:O}

[]= Left Table's Relationship view of relationship
{} = Right Table's Relationship view of relationship
T = Relationship type of The Table in Question (as indicated by [] or {} in my diagram)
O = Relationship type of The Other Table in Question
? = Operator

Each Table Sees itself as the Left side of the Join and the other table as the Right (this is to help alleviate Right vs Left outer join performance)
The Cardinality drop down is showing you what that table would see the other table as if it were the Left side of the Join

So Table A and Table B:

[1:1] = (1:n)

Table A (marked with []) is related to Table B as 1:1 (A on left B on right)
Table B (Marked with {}) is related to Table A as 1:N (B on left A on right)

So for an INNER Many to One Relationship between Table A and table B you set:

1:1 = 1:N

For an OUTER Many One to One Relationship:

1:1 = 0:N

Comments

Popular posts from this blog

Query Cognos 8/10 Content Store

Cognos 8/10 CAMID-User ID/LDAP ID report

How about an Online help forum?