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.