Forum Discussion
Model Design and Dates
Hi I have a data model that has a date table and fact tables. I am having issues with the model design. The date table needs to relate to the fact table by year and month, only this is not possible d...
If you did that, add the YMW column to your date table, your join to your fact table would be many to many unless I am not understanding your post.
Oh jeez. You are 100% correct. I completely overlooked that. Good call! Thank you 🙂