mschwade
asked on
Unable to access the Microsoft Office Project Portfolio Analyzer OLAP cube.
I am in PWA and click on Admin, go to Manage Views, and then try to select the top view under Portfolio Analyzer views and I get the error message: Unable to access the Microsoft Office Project Portfolio Analyzer OLAP cube.
Now here's the deal... we've isolated it to an issue with my PC.. My boss logged into my notebook and was NOT able to view, though he is able to view it on his notebook. I logged into his notebook with my windows account and was able to view it now. I reinstalled the OWC11.exe that I downloaded from the web, but that didn't work. Is there a difference between the OWC11.msi on the O2k3 Pro disk as oppossed to the OWC11.exe downloaded from the web?
Thanks,
MS
Now here's the deal... we've isolated it to an issue with my PC.. My boss logged into my notebook and was NOT able to view, though he is able to view it on his notebook. I logged into his notebook with my windows account and was able to view it now. I reinstalled the OWC11.exe that I downloaded from the web, but that didn't work. Is there a difference between the OWC11.msi on the O2k3 Pro disk as oppossed to the OWC11.exe downloaded from the web?
Thanks,
MS
ASKER
I've already tried that :(
ASKER
I clicked the apply button underneath the error message and the server and cube (below):
Analysis Server:
Cube Name:
and I get this under the Customize the PivotTable:
No Details
The query could not be processed:
o Unable to connect to the Analysis server. The server name 'prdsql' was not found. Please verify that the name you entered is correct.
Analysis Server:
Cube Name:
and I get this under the Customize the PivotTable:
No Details
The query could not be processed:
o Unable to connect to the Analysis server. The server name 'prdsql' was not found. Please verify that the name you entered is correct.
ASKER
Before you ask, prdsql is correct.
Are you able connect to the cube from MS Excell?
ASKER
Sorry for my ignorence, how do I test that out?
Thanks,
MS
Thanks,
MS
ASKER
Heres what i got from Excel:
Unable to open connection.
Unable to connect to the Analysis server. The server name 'prdsql' was not found. Please verify that the name you entered is correct, and then try again
Unable to open connection.
Unable to connect to the Analysis server. The server name 'prdsql' was not found. Please verify that the name you entered is correct, and then try again
On your server is probaly installed SQl 2000 SP4 but PTSFull.exe wasn't installed on your computer.
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32asp4.htm#_analysis_services_enhancements
section 5.1.2
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32asp4.htm#_analysis_services_enhancements
section 5.1.2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I added the prdsql static entry in my host record and it works now!
Thanks,
MS
Thanks,
MS
tools/ internet options/security/ select trusted zone/ click to buttom custom ..
find item
Miscellaneous\ Access data sources across domains
and select Enable.
PS I'm not MS Employe :)