AdventureWorksDW2008R2 DimDate table has missing dates


There is a gap in dates between 2008 and 2010 in the AdventureWorksDW2008R2 DimDate table. PerformancePoint Server (and Services) requires continguous dates for the Time Intelligence feature to function properly. Please ensure the records in the DimDaet table are contiguous.

file attachments


pavanbarnala wrote Feb 23, 2012 at 11:47 AM

Is this been taken care? If so, please share the latest data for DimDate. I'm working on some POC which requires dates in between 2008 and 2010 as well. If it is not already done, can someone let me know is there is any way I can generate the data for those missing dates in that table?

petermyers wrote Feb 26, 2012 at 6:21 AM

The attached script will fix the problem. Use the stored procedure to extend to future dates if needed.