So, migrating an OLAP cube / database from AS 2000 to AS 2005 seemed like a breeze. Most of it is, anyway. But for some reason, my Time dimension gets all messed up in AS 2005. It's broken into Year, Month and Day. THere are some days and months in 2004 and 2005. The original 2000 cube gets it right, giving me [2004].[200411] for November 2004 and [2005].[200511] for November 2005. After processing the migrated database, I get [2004].[[200411], and [2005].[200411]... Which off course messes up my queries big time because it's plain wrong.
It's probably a reason for this. I'll play detective tomorrow...