linking two facts

can any one help me to link two fact table in BO…


hemalatha (BOB member since 2004-07-20)

Just add a join(s) :smiley: between the two tables on related fields


Rich :uk: (BOB member since 2002-10-04)

Select Tables in Designer…
Right-click mouse button…
Join…
Select correct collumns…
[OPTIONAL]
Detect cardinality…
[/OPTIONAL]
“Ok”
[OPTIONAL]
Create Context
[/OPTIONAL]

Or u could opt for ?


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

Keep in mind that joining fact tables might create fan traps.
If you do not know what fan traps are I suggest a search on BOB, a training class, and maybe a book or two :wink:

The best way to relate fact tables usually is via shared/conformed dimension tables (this will create a chasm trap, which in turn can be resolved via contexts).


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