setting cardinalities; to do or not to do

Hi,

In some universes i come across the following issue… some of the joins do not have set the cardinality… why is that?

i’ve tried several cardinalties but apperently this doesn’t affect the outcome, only setting the outer join. So what is the use of setting the cardinality?


E10 :netherlands: (BOB member since 2003-04-16)

A) If you ever wanted to use the detect context wizard you need to set cardinalities.

B) One needs to know cardinalities in order to determine possible fan/chasm traps.


Andreas :de: (BOB member since 2002-06-20)

Aa if you’re not using this gandalf thing for detecting contexten but do it manually? I have seen contexten without the cardinality set

Bb agreed

But still it doesn’t answer the question whether is would make a difference reagarding the data in general whether it’s usefull setting the cardinality…


E10 :netherlands: (BOB member since 2003-04-16)

It matters if you’re measure-data is in different contexts. And you want to detect contexts automatically. That’s the only reason I was learned to use cardinalities.

It makes “reading” the data model easier too of course. But regarding the data it doesn’t matter, as long as you don’t have any fan- or chasm-traps in your model. It doesn’t do anything with your SQL if you’re not using contexts, if that’s what you’re asking.


jobjoris :netherlands: (BOB member since 2004-06-30)

thanx!


E10 :netherlands: (BOB member since 2003-04-16)