Forum Discussion
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 |
4 Replies
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 |Hi proavinash,
As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay PabbuHi @proavinash,
As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay PabbuHi @proavinash,
As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay Pabbu
