Column length in SQL 2005 Analysis Services cube

I’ve been dark for a while as I’ve been on holiday in Turkey on the ‘Tourqoise Coast’. Great people, hot and sunny, amazing diving water, thoroughly recommended.
Anyway. I had a new one today with a cube. A few weeks ago, in the underlying database, a varchar column’s max length was increased from 50 to 100. The cube continued to build fine until somebody created a new row with a value longer than 50 characters. The cube failed to build with an error about binding. Annoyingly, refreshing the data source view wasn’t enough. I had to go into the dimension and actually update the properties there too.
Worth bearing in mind.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s