When the process button is clicked after creating a hierarchy, it fails, then suggests that a dimension does not contain hierarchies or that the time dimension is not created. It doesn't work when clicking the process button (right click the name of the dimension from the solution explorer) but seems to generate a dimension correctly from a line that indicates a datasource view. Processing Dimension Attribute '(All)' completed. Start time: 11/15/2010 2:25:18 PM; End time: 11/15/2010 2:25:18 PM; Duration: 0:00:00 Processing Dimension Attribute 'Day Of Half Year' completed. Start time: 11/15/2010 2:25:18 PM; End time: 11/15/2010 2:25:18 PM; Duration: 0:00:00 Processing Dimension Attribute 'Day Of Year' completed. Start time: 11/15/2010 2:25:18 PM; End time: 11/15/2010 2:25:18 PM; Duration: 0:00:00 Processing Dimension Attribute 'Year' completed. Start time: 11/15/2010 2:25:18 PM; End time: 11/15/2010 2:25:18 PM; Duration: 0:00:00 Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Server: The operation has been cancelled. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; OR (change to another user where the result looks a bit different): THEN "process" the dimension: The following system error occurred: Logon failure: unknown user name or bad password. . Since in none of the four cases for impersonation (user account, windows user account, credentials of user, or inherit) should fail to have an incorrect password, this can be rather a confusing error. WHat exactly is logging on? This looks like a logon to the source database. Is it trying to log into the target datawarehouse that is being created? Does it need file access? (THe users tried should have all of these permissions). Does the system require that Microsoft Office is installed somewhere?

Have you tried deleting the database from Analysis Services, redeploying, and doing a full process? Looks like you have an issue with the credentials in one of the datasources of your project. You should probably ask this question in the analysis services forum - as this is an RS forum.