7.0 - Data summarization fails due to DimDate error


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


Posted Friday, June 06, 2014 by andrew_montpetit
http://micc.mitel.com/kb/KnowledgebaseArticle52151.aspx