Portfolio Analyzer

[Joe]

Hi Everyone,

I need your help if anyone has a solution. I have two servers, one Proj
server 2003 with SP3, IIS 6.0, DSO with SP3a and sharepoint 3.0 with SP1 and
the other server is SQL 2000 with SP3, Analysis Server with SP3a. Cubes get
created successfully and I can see them in the Analysis server. I modify the
permission for that specific cube and add OLAP Administrators Group to it.
When I go to PWA under Admin and then Manage Views, I click on Portfolio
Analyzer, after 2 seconds, I ge the following message:

Unable to access the Microsoft Office Project Portfolio Analyzer OLAP cube.

Possible Cause : The cube has not yet been built, or it is currently being
generated, or you do not have permission to access the cube.

My account is part of the OLAP administrator's group which has access to BIN
and Repository folder. I also followed the Article # 324836 and many other
articles from Microsoft and other discussion groups but it just doesn't work.

Any idea what's wrong or where it needs to be configured? Any help would be
really appreciated.

Thanks

 

[Marc Soester [MVP]]

Joe, go to your browser settings, add the PWA site to your trusted sites and
ensure that the security for trusted site has the following 2 settings set:

- under "Miscellaneuos, set the "Access data sources accross domains" to
enable
- under "User Authentication" set the "Automatic logon with current user
name and password".

this will hopefully do the trick Let me know how you go
Marc