Solved

Analysis Services connectivity problems

Posted on 2004-08-18
3
709 Views
Last Modified: 2010-10-05
Hi,
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!!
0
Comment
Question by:BillAn1
3 Comments
 
LVL 17

Author Comment

by:BillAn1
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.
0
 

Accepted Solution

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

Expert Comment

by:BoltonWanderer
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?

Cheers

Chris
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
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 friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 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

13 Experts available now in Live!

Get 1:1 Help Now