Solved

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

Posted on 2006-11-21
10
1,154 Views
Last Modified: 2013-11-15
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
0
Comment
Question by:mschwade
  • 6
  • 4
10 Comments
 
LVL 10

Expert Comment

by:winzig
ID: 17989229
it's problem caused by security settings in your IE

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 :)
0
 
LVL 1

Author Comment

by:mschwade
ID: 17989585
I've already tried that :(
0
 
LVL 1

Author Comment

by:mschwade
ID: 17989785
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.
0
 
LVL 1

Author Comment

by:mschwade
ID: 17989786
Before you ask, prdsql is correct.
0
 
LVL 10

Expert Comment

by:winzig
ID: 17990084
Are you able connect to the cube from MS Excell?
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 1

Author Comment

by:mschwade
ID: 17990160
Sorry for my ignorence, how do I test that out?

Thanks,
MS
0
 
LVL 1

Author Comment

by:mschwade
ID: 17990577
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
0
 
LVL 10

Expert Comment

by:winzig
ID: 17991225
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
0
 
LVL 10

Accepted Solution

by:
winzig earned 500 total points
ID: 17991276
are you able to ping  server prdsql ?

If you are can you install Management tools on you desktop and connect to server.

is it the same computer ? http://www.experts-exchange.com/Applications/MS_Office/Microsoft_Project/Q_22047206.html
0
 
LVL 1

Author Comment

by:mschwade
ID: 17995235
I added the prdsql static entry in my host record and it works now!

Thanks,
MS
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now