7.0 - Data summarization fails due to DimDate error

Expand / Collapse
 

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



Rate this Article:
     

Attachments


Add10YearsToExistingDimDate.zip Add10YearsToExistingDimDate.zip (831 GB, 384 views)

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Friday, June 06, 2014
Last Modified By: andrew_montpetit
Type: FIX
Article not rated yet.
Article has been viewed 3,080 times.
Options