SQL Server Analysis Services Authentication Freak Out

[Rant On]

What is the deal really with the anti-user intuitive situation with analysis services when it decides that the data connection to a data source needs to use some arbitrary user authentication!  I had my SSAS cube set to process against a nice normal authenticated account and somehow, someway it went and stuck some completely unrelated user in the account login for the data source.  Now how is that supposed to help anything?

[Rant Off]

Needless to say, I’m looking forward to SQL Server 2008.  I hope it truly is cleaned up a good bit and as streamlined for cubes as I’ve been hearing.