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. <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Parallel> <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100"> <Object> <DatabaseID>ResNetQADW</DatabaseID> <DimensionID>Time</DimensionID> </Object> <Type>ProcessFull</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch> Processing Dimension 'Time' 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 '(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'.; 28000; Cannot open database "resnetqa" requested by the login. The login failed.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Resnetqa', Name of 'Resnetqa'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Year' attribute of the 'Time' dimension from the 'ResNetQADW' database was being processed. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; 28000; Cannot open database "resnetqa" requested by the login. The login failed.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Resnetqa', Name of 'Resnetqa'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. Errors in the OLAP storage engine: An error occurred while the 'Day Of Year' attribute of the 'Time' dimension from the 'ResNetQADW' database was being processed.