Forum Discussion

bininja's avatar
bininja
Icon for Helper I rankHelper I
7 years ago

Connect multiple fact tables with multiple dimension tables

Hi guys,   I have a issue with relationships.   I have multiple fact tables with multiple columns of primary keys. Then I have multiple dimension tables where each table should be connected to a...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

bininja well then it shoudl work, one thing is not clear, do you have duplicate for each dimension or same dimension table connects to both fact, if it is the later one then everything should work.

bininja's avatar
bininja
Icon for Helper I rankHelper I
7 years ago
parry2k I have one dimension table for each dimension. Each dimension table is connected to the facttables.

I earlier tried using one table as dimension table but I was then only able to makw the relationship wirh fact table on one column and that didnt work as I wanted it to.