An error similar to the following appears in the Build Tracking Comments log:

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database db10073 on the <servername> server. Error: OLE DB error: OLE DB or ODBC error: Login failed for user 'Domain\User'.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'db10073', Name of 'Issue Created Date' was being processed. OLE DB error: OLE DB or ODBC error: Login failed for user 'Domain\User'.; 42000.

The precise set of errors that are emitted will depend on the nature of your cube. The error message string is likely to be very long, with repeating information.

The error can be caused because the account of the service running SQL Server Analysis Services does not have access to the Project Server Reporting database.

Run the service as a user who has at least read access to the reporting database. For more information, see Chapter overview: Configure Office Project Server 2007 to use the Cube Building Service.

This topic is included in the following downloadable book for easier reading and printing:

• Cube Building Service in Office Project Server 2007

See the full list of available books at Downloadable content for Project Server 2007.