can any one help me to link two fact table in BO…
hemalatha (BOB member since 2004-07-20)
can any one help me to link two fact table in BO…
hemalatha (BOB member since 2004-07-20)
Just add a join(s) between the two tables on related fields
Rich (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 (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
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 (BOB member since 2002-06-20)