Analysis Services connectivity problems

Posted on 2004-08-18
Medium Priority
Last Modified: 2010-10-05
I have Analysis Services running on a Win2K server. I can connect to the cube through Excel no problem from a PC that is physically in the same building as the server.

In another site, I log on to a PC as the same user, and I cannot now connect to the cube.

I get the 'Excel cannot find OLAP cube...' error message. However, I can connect to the server, e.g. I can use remote desktop to the server, and then log in as the same user on the server, and browse the cubes.I can also map to a share on the server and pull down files etc.

The user I am logging in as is a member of the OLAP Administrator group on the server.

Any suggestions regarding where I should start to look would be greatly appreciated!!
Question by:BillAn1
LVL 17

Author Comment

ID: 11831678
OK, I sorted the problem out!
The issue was that the client PC was using Excel2000. By default, Excel2K comes with the driver for SQLServer7.0 OLAP provider, but not SQLServer 2000. Normally, there is no problem, the 7.0 Driver can connect to a 2000 cube etc. However, the cube in question had a parent-child dimension. When this is used, the cube is no longer 'visible' to Excel, using the 7.0 Driver.
To confuse the issue, the first client PC I went to did have the same version of Excel, but at some stage somebody had installed the more up-to-date drivers.

Accepted Solution

RomMod earned 0 total points
ID: 11833829
The question has been PAQ'd and the 500 points have been refunded.
Community Support Moderator

Expert Comment

ID: 14549118
Hi BillAn1 - I have exactly the same problem on one pc on our network.

Can you tell me where you get the 2000 driver provider?



Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

624 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