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
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
understood now. created calendar and hour table and joined the timestamp with facts