Solved

Excel 2003 & Windows 7 error when connecting to SSAS cube

Posted on 2010-11-25
7
1,375 Views
Last Modified: 2012-08-14
Hi All,

I have a frustrating error that I have not been able to resolve through the usual channels.

I am attempting to connect to a data cube (SSAS) via excel 2003 on any machine running windows 7.  The error received is :

"Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server.
Contact the OLAP cube administrator and, if necessary, set up a new data source to connect to the cube."

I have multiple cubes on multiple SQL servers running SSAS 2005 + SSAS 2008R2, neither work.

When I use excel 2003 with windows XP I have no issue, nor with Windows 7 and Excel 2007 or 2010.

The windows firewall has been disabled and all microsoft updates have been applied.

It is not practical to upgrade Excel on these machines just yet due the number of machines and training issues.

Any help greatly appreciated!

Cheers
Rob
0
Comment
Question by:PitcherICT
  • 5
  • 2
7 Comments
 
LVL 15

Expert Comment

by:CSLARSEN
ID: 34218214
Hi
I would look into the drivers used.
I believe SSAS used different drivers depending on the SSAS version of the server.
Cheers
cslarsen
0
 

Author Comment

by:PitcherICT
ID: 34224013
Hi,

I have installed the same SSAS driver on both XP and win7 which allows access to read the cubes (SQLSERVER2008_ASOLEDB10 with win7 support) XP has no issues.

This is the SSAS 2008R2 driver and is compatible for ssas 2005 and 2008.  I have also tried the SSAS driver for SQL 2008 to no avail.  I suspect this is not a driver issue, it is more to do with WIN7 and excel 2003 compatibility ?

Rob

0
 
LVL 15

Expert Comment

by:CSLARSEN
ID: 34224470
ok, thats a tricky one.
Unfortunately I do not have a 2003 on win7 for testing.
I can confirm
I have xl2003 on xp with 2005/2008 ssas connections: no problems
I have xl2010 on win7 with 2005/2008 ssas: no problems

good luck
cslarsen
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:PitcherICT
ID: 34253227
I've logged this with MS, they could not resolve it in a live meeting session, they are setting up a test environment of their own to try and resolve, I will post the resolution here to share the love.
0
 

Accepted Solution

by:
PitcherICT earned 0 total points
ID: 34255061
OK - I have found the answer to this issue, and here it is.

I setup an analysis services trace and attempted to connect to excel (pivot table)
This captured an error talking about locale.

To resolve I changed the WIN 7 machine regional settings from English (Australia) to English (US) and then back to English (Australia) and now it works!

Weird but it works.
Thanks
Rob
0
 

Author Comment

by:PitcherICT
ID: 34255067
correct
0
 

Author Closing Comment

by:PitcherICT
ID: 34281244
Tested and agreed
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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