How do you create a relationship with date table in SQL Server Data Tools
Posted on 2014-08-18
I am using SSDT 2012 to create a tabular model. I have several tables (Order, Order Details, Delivery Details, Item Details etc.) All of these are working fine. I have created relationships between these tables and I can sort and sum my data. My issue however is creating and assigning the date table. I created a data table with many date columns (Date, Month Name, Year, FY etc.) but I cannot get this table to work with all the others. I assigned it as the date table and marked the date column. Then when I do a report and select FY 2015, if gives me every order from the order table. If I create a relationship between the Date field and the Order date field, then it works. However, I cannot have another active relationship with the delivery date and Date field. So in short, how to I make the date table work with all the other table's date field?