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 you don't need cross filter to both, can you share relationship diagram you have.

  • bininja's avatar
    bininja
    Icon for Helper I rankHelper I
    7 years ago
    parry2k Thanks for your reply. The diagram is just as I have posted above. One to many relationship for all of them.
    • 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.