Forum Discussion
Solved
Data Modeling - Dimension Date
Hi, I have 3 fact tables with 2 different Date type Date Fact 1 and 3 Date Fact 2 01.01.2000 2016 Q1 01.01.2000 2016 Q2 01.01.2020 2016 Q3 30.01.2017 2016 Q4 3...
The approach I take is to add a date column to the fact table. This allows you to create a relationship with DimDate.
To create a date column in the fact table, you can use any date in the period. I prefer to use the first date of the period since all months have day 1, but not all months have day 31. For example, "2016 Q1" would be 2016-01-01 (assuming your quarters are based on a calendar year).
Many thanks for your advice.