Hi,

i want to relate 2 or more fact tables (FT) and that FT shares 2 or
more dimensions.

my problem is when i ask for FT's indicators respect to the shares
dimensions, i will make a loop with my query?

how i can relate two FT who shares dimensions?

with a relational model happens the same?

greetings,
diego.

Diego,
You'll need to be more specific with regards to what OLAP tool you are
using.

-Tri
On Mar 7, 11:00 am, "darenasc" <daren... (AT) gmail (DOT) com> wrote:

i use BO to visualize fact tables made in sql server 2000. that FT are
not related, but i want to analyze indicators of both FT (like sales
and costs) through shares dimensions (like client and product).

how can i do this?

thanks,
diego.

PS: i know what i can merge dimensions or link data in the reports,
but i want do this in de model.

On Mar 7, 10:17 am, "darenasc" <daren... (AT) gmail (DOT) com> wrote:
Seems like you need to join the fact tables on their keys in the
relational source. The keys may not be materialized in the views that
you are using, resulting in the "loop" you describe when you are
trying to join (cartesian product) you may need new views that join
this data for you.

Maybe I'm missing something (quite possible), but could you not simply
create an alias for each of the dimension tables and join the sales fact to
the physical dimension tables and the costs fact to the alias tables?


"JM" <mcahren (AT) gmail (DOT) com> wrote