Problem with OLAP Cube View Acess

[Ian Gallagher]

Hello,

I have a two server configuaration and I get the "Unable to access the
Microsoft Project Portfolio Analyzer OLAP cube" message when I try to
create a view in the Portfolio Analyzer"

The cube is sucessfully created, both systems are on a domain, domain
accounts are created and are currently in use.

THE PROBLEM:
Views can be created and viewed on the system where SQL Server and SQL
Analysis is located but on any other system I get the "Unable to
access the Microsoft Project Portfolio Analyzer OLAP cube" message
when I try to create a view in the Portfolio Analyzer"

 

[Vinh Tran]

Install Office XP. You need it to create views.

It works on the server, because Project Server installs
the Office Web Components with the create permission.

It won't work on Desktops without it.




Vinh

 

[Ian Gallagher]

Office Web Componets are already installed and the non-server systems
can successfully access the development Project Server OLAP views.

 

[Vinh Tran]

Office Web Components DOES NOT give you Create/Write
permissions on Views. You can't create a view.

However, you can still SEE views that are created by
others (the ones you created on your SQL Server).


Vinh Tran

 

[Jill B]

For clarification of this see the bottom of the
http://www.microsoft.com/office/project/evaluation/svrsysreqs.asp web page.

 

[MutazAG]

what is the user account u use when connecting from the server? i assume an
administrator account. this has complete access to the cube. to enable other
NT users to access the cube u need to grant them access permissions on the
cube it self.