Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Very simple relationship not working...

Hi BI gurus,   Amature poster here back with an embarrassingly simple issue I can't see to figure out...   I can't seem to clear the "This cardinality isn't valid for the relationship you have se...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Anonymous 

    When many to many relationship, you can select both way filter you needed or which table to which filter you are looking for.
    Also if it is showing OK button, still you can use the relationship and filter the data

    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 

You did not mention which column you are using in a relationship. I am assuming you are using the Year column (as the same column is present in both screenshots)
So 2024 is present in both tables multiple times, the relationship should be many to many
Now the question is, how do you want to filter the data? Both-way filter or single-way filter.
For a better relationship technique, please use One to Many or Many to One, 

Please share more details and other table relationship as well

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi PijushRoy, yes I am trying to link Year in both tables so that in my report I can slice a visual that displays the budget amount, first for 2024 and then for more data as it's added in. With that in mind I think the relationship should be one (dimension table) to many (date table) but it keeps running into the aforementioned error

    • PijushRoy's avatar
      PijushRoy
      Icon for Community Champion rankCommunity Champion
      2 years ago

      Hi Anonymous 

      When many to many relationship, you can select both way filter you needed or which table to which filter you are looking for.
      Also if it is showing OK button, still you can use the relationship and filter the data

      Let me know if that works for you


      If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

      Thanks
      Pijush
      Linkedin