Joining the fact tables

HI,
I have multiple fact tables in my schema how do I get data from Two or more fact tables, can I join the Surrogate keys between the facts or should I go through some common dimensions.

Thankyou


poltergeistr (BOB member since 2004-04-21)

It is (almost?) always preferable to join through the common dimension table. If you are not familiar with Contexts in Designer, they are the solution to your situation. Easily one of the more powerful features of Business Object.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

If you have understood star schema well then this question should be answered well… Search for Star schema in GOOGLE and jus give a thought about it :slight_smile:


cpmohanraj :australia: (BOB member since 2002-09-23)