When a fact table is at a higher granularity to the date dimension (e.g. monthly) how should this be represented as a relationship in the data source view?
With a date dimension containing columns
MonthDateKey and fact table containing
MonthDateKey should the relationship be:
Fact.MonthDateKey -> Date.DateKey or
Fact.MonthDateKey -> Date.MonthDateKey
What are the implications if this is set incorrectly in the data source view?