Share via

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.

Comments

  • Anonymous
    March 01, 2007
    I'm still getting this error even though I followed the recommendations from the TechNet article.  I have two servers, one that is hosting MOSS (farm installation on a single server), PWA and the Project Server Application tier.  I have a second server that is only hosting the Project Databases.  I have configured the MOSS server and Project DB Server with all the updates as per Technet and I still get the exact same error.  Any ideas?  

  • Anonymous
    March 07, 2007
    I'll be focusing on configuration and permissions first. 1: Configuration: What is the exact <DSO> tag that you pasted into configmsmdsrv.ini? Verify it's got the correct computer name, SQL Server location, and correct SQLServer instance number in <DSO> 2: Permission:  What accounts are listed for DSO9 folder?  1: Properties of DSO9 folder -> Sharing tab --> Permission button  2: Properties of DSO9 folder --> Security tab Verify “SQLServer2005MSOLAPUser$analysisservername$instancename” has readwrite permissions to the DSO9 folder.

  • Anonymous
    March 16, 2007
    The comment has been removed

  • Anonymous
    April 24, 2007
    I have been over and over the KB article, and I am still completely lost.   The KB refers to an MDB file that I just do not have. My DSO settings in my Analysis Server Properties look like this: Provider=SQLNCLI.1;Data Source=JEFFERSON;Persist Security Info=True;Password=**********;User ID=sa;Initial Catalog=stavdso When I test this connection string, it succeeds. I am confused about the whole DSO9 folder share and permissions, as I am trying to create these tables in SQL. What the heck am I doing wrong.  Will this just not work this way, and must I find the MDB file?

  • Anonymous
    May 22, 2007
    You MUST have the mdb file. There is simply no way around it. Microsoft knows about this problem, and it is aware that it is not in the documentation. I am a MS Partner, and the group I am with has called microsoft directly about this matter.

  • Anonymous
    May 22, 2007
    I have successfully buid the cube with Project Server 2007 Thanks for the support Simon.