Time Dimension and Adding Intelligence in SSAS

If you are building a Analysis Services cube by trying to take advantage of the inbuilt time dimension. This article is a must read.
http://www.mssqltips.com/tip.asp?tip=1454
It also explains in detail about adding the built in features of business intelligence to the generated hierarchy and provides some calculation for periodic growth figures.

SSAS Error: OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.; 28000.

I was trying to deploy the a cube into Analysis Services DB, present in a different server from my development machine (BIDS) and this is the first among many errors i got.

OLE DB error: OLE DB or ODBC error: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.; 28000.

Took a look at my data sources, and on the impersonation tab, i played around with the different options available. I had set it to "default" and i was able to deploy to the localhost. Now i tried all the other options like “Use the credentials of the current user” but got errors.

I have found that “Use a specific user name and password” works. But i tried to specify a username and password thinking it will assign this specifically to the cube, but again errors. I found out that it is actually expecting for the windows user name and password. So in my scenario it works well when i gave my windows authentication - domain/username and then password.