Article ID: 52151 - Last Review: June 6, 2014
PROBLEM
When summarizing phone data into the database, you encounter an error referencing the DimDate.
CAUSE
Your database contains a table pre-populated with dates ranging into the future, but it does not extend far enough.
WORKAROUND
On the SQL server, unzip and run the attached script to add 10 years worth of dates into the table.
NOTE: You will need SQL Management Studio installed in order to run this script.
RESOLUTION
We will be adding this time automatically in release 7.1 and later.
APPLIES TO
7.0.1.0
Keywords: DimDate summarize resummarize