Unable to Access OLAP

[Eric Stevens]

I have setup a Project server, SQL2000 and analysis tools,
and sharepoint team services all on the same server. The
main reason is so that a group of my guys can manage their
projects through the project server web. They can also
use sharepoint team services to do document tracking and
SQL analysis to create views and reports based on project
data published to the project server. My problem is when
I use the project web to create the OLAP cube it creates
it fine and populates it with data. Then you have to add
an analysis view using the project server web, but when I
do this from any other box besides the
Project/SQL/Sharepoint server I get an error that it is
unable to access the cube. I setup everything the way MS
suggests, I am running all the latest service packs for
both windows and SQL...any suggestions?

 

[Gary Chefetz [MVP]]

Eric:

Users must be added to cube roles explicitly. This setup step is described
in pjsvr10.chm (the installation guide) under steps after installing Project
Server.