Forum Discussion

Youssef_Hamed's avatar
Youssef_Hamed
New Member
2 years ago
Solved

Relationship Issue Between Year Dimension and Fact Table

Description: I created a year dimension table with distinct years and linked it to the year column in my fact table. The relationship doesn’t work unless I set the cross-filtering option to "Both." ...
Tips and Tricks
  • Youssef_Hamed's avatar
    Youssef_Hamed
    2 years ago

    Hello Ashish,

    Thank you for your helpful response!

    I believe the issue might be that when I tried creating the calendar table, the relationship setup window was too large, hiding the "Save" and "Cancel" buttons at the bottom. As a result, I may have mistakenly selected the wrong option while navigating with the Tab key.

    Do you happen to have a solution for resizing or adjusting the window so that all options are visible?

    I’ll give it another try following your advice.

    Thanks again for your guidance!

    Best regards,
    Youssef Hamid

Youssef_Hamed's avatar
Youssef_Hamed
New Member
2 years ago

Hello Ashish,

Thank you for your helpful response!

I believe the issue might be that when I tried creating the calendar table, the relationship setup window was too large, hiding the "Save" and "Cancel" buttons at the bottom. As a result, I may have mistakenly selected the wrong option while navigating with the Tab key.

Do you happen to have a solution for resizing or adjusting the window so that all options are visible?

I’ll give it another try following your advice.

Thanks again for your guidance!

Best regards,
Youssef Hamid

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

You are welcome.  No, i do not.