Solved

Analysis Services connectivity problems

Posted on 2004-08-18
3
710 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Linking to Report Server Shared Data Source 4 110
Average Calculation - SAP Lumira 1 132
Sum Of Group In SSRS Report 18 84
Cognos BI 7.5 calculated date syntax 2 40
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 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

18 Experts available now in Live!

Get 1:1 Help Now