Forum Discussion
SevsBo
Responsive Resident
Responsive ResidentCannot create single direction one-to-one relationship
I have created a relationship between a generic Date table and a table that containst a Date column. The relationship is identified as one-to-one, given that the date data is quite short and distinct...
MattiaFratello
Super User
Super UserHi SevsBo, may I ask you why you need a Date Table if your fact table has already unique dates?
SevsBoResponsive Resident
Responsive ResidentBecause it only has a handful of dates - starts of each month to be precise. I need to filter this, along with other data at the same time, on a monthly level so I need a separate date table to control that.