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
bininja's avatar
bininja
Icon for Helper I rankHelper I
7 years ago

parry2k Thanks for helping me out on this. 

 

Here is the file: https://filebin.net/f31diioljvh8zl40

 

As you can see in the file, I have already sliced on one of the slicers. I want the other slicers on the page to sync with the selected value in the slicer and only show values in all slicers which are related to the chosen one. I hope you understand me. 

 

Let me know if there is something.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

bininja I now understand what you are trying to do, here is the post which can helpt but not sure what is the use case you need to do this. Hope above link helps

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

    parry2k Thanks. This looks good. The thing I am not sure about is how this will work since I have multiple fact tables..?