Error Date table relationship with other date table

Hello proavinash ,

In the SalesDump table, I noticed it has many-to-one relationships with other tables that are not visible. My assumption is that you’re using something in the visual layer that indirectly connects to the DimDate table. If you’ve created multiple active relationships between the same tables, that could be causing the confusion. While connecting both directions might seem to solve the problem temporarily, it is not considered best practice. Instead, I recommend establishing one-way relationships from the fact tables (e.g., Deliver) to the DimDate table.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |