Forum Discussion
Dim_Date join with multiple fact date column
Hi All, I have 3 tables Dim_date (datetime) Fact1 (datetime) Facts 2(datetime) RealtionShip Fact1 (datetime) 1:M Dim_date (datetime) Crossfilter direction (BOTH) and Active/ Fact2 (da...
Not clear. But make sure that both table are joined on Date column with date table having no time. Also, all dates are cover in date dimension
if i dnt join on datetime, how can i extract hourly data
Best practices want the Dim_Date to be a list of distinct days with no gaps, with no time.
In this way you will be able to use it as a calendar table for your model and to use all the Time Intelligence functions.
In your fact you should calculate the date and link it the Dim_Date with a 1:M relationship that goes from Dim_Date to Fact.