Building OLAP Cube with Project Server 2007

  • Article

Lots of our customers have started to deploy Project Server 2007. One of the common questions is how to configure Project Server 2007 to build cube on SQL Server 2005 and Analysis Service environment.

It's important to know that information in MS article 921116 still applies to Project Server 2007. The server hosting the Project Server must have the Analysis Services DSO component installed.

KB 921116 Error message when you try to build an OLAP cube in a deployment of Project Server 2003 that uses SQL Server 2005 Analysis Services: "Could not connect to the OLAP server specified" https://support.microsoft.com/default.aspx?scid=kb;EN-US;921116

1: Here’s the excerpts of status report in Office Project Web Access page without DSO configured.

===== Building database and cubes =====

[2/12/2007 1:55 PM] Cube build session started

[2/12/2007 1:55 PM] Analysis Services session started

[2/12/2007 1:55 PM] Analysis Services session failed with the following error: Failed to connect to the Analysis Services server YourServerName. Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

===== Process Completed =====

[2/12/2007 1:55 PM] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server YourServerName. Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>...</DSO> section in msmdsrv.ini file from Analysis Services 9.0).

2: Excerpts of Status Report for a successfully build cube in Project Server 2007

===== Processing OLAP database =====

[2/12/2007 2:52 PM] Process OLAP database session started

[2/12/2007 2:52 PM] Analysis Services session started

[2/12/2007 2:53 PM] Analysis Services session completed successfully

===== Verifying and running post-process server event handler =====

[2/12/2007 2:53 PM] Verifying and running post-process server event handler

===== Process Completed =====

[2/12/2007 2:53 PM] Cube build request completed successfully.