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

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