I have a dimension table that has ship-dates and I'm trying to tie that to my Fact table that uses a Plan date. The issue
is the Plan date is carried for for all months for current year. The dimension table which has ship dates only has records for shipments which includes current year and current month plus previous months. When I rebuild I get missing date for 2015-08 which I expect, but how can I get around this error. They want to see Plan data for Current year and all month, but I don't
have that corresponding data in dimension table. 

 Thanks.

Hi h,

How about inserting more dates into your Date dimension?

ie 

Insert into DimDates (TheDate)

   Select distinct ShipDate from tbShipments where ShipDate not in (select TheDate from DimDates)

Hope that helps,