Can access the OLAP cube only on the Project Server

[Denis in Brisbane]

Environment - Project Server box and separate SQL server.
Analysis Services is installed on the Project Server box.
Cube database is on the SQL server.
We appear to have all the correct versions of software and have run PSCOM+
to define the OLAP administrator as the .

We have successfully generated an OLAP cube (it now happens automagically on
a daily basis). I've defined Protfolio Analyzer views.

It all works like a bought one when I'm on the server. When I'm on any
other PC, I get the message "unable to access the Microsoft Office Project
Portfolio Analyzer OLAP Cube".

I have a sneaking suspicion that it's related to cross-domain access. The
user PCs are not in the same domain as the servers. They're hopefully moving
to AD next week and I'm hoping that all these problems will go away (but not
with a lot of confidence).

Any assistance would be welcome.

Denis

 

[Denis in Brisbane]

I solved my own problem!!

One thing I omitted to mention was that we had moved Project Server and
Analysis Services to a different server, pointing to the old database.
However, the views were still defined to point to the old server. All I had
to do was make sure that the view pointed to the right server and it
magically worked.

One for experience.

Denis