samedi, juin 10, 2006

Ms Project OLAP generation problem

When I tried to generate Olap cubes using the project web access an error is fired: "ould not connect to Olap server”, I checked the events logs, I found this entry: "he connection string to repository needs to be specified in the 9.0 server properties" I think every one could have this problem when he used the sql server 2005 as the database server with MS Project server 2003. To resolve it :

Go to the management studio, connect to Analysis services server, right click and go to server property. Then check show all properties, look for DSO\ReposityConnectionString and define the connection string there.
Now try to rebuild the cubes!

Aucun commentaire: