Solved

Analysis Services connectivity problems

Posted on 2004-08-18
3
714 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
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…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

728 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