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
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
Post a Comment