Solved

Excel 2003 & Windows 7 error when connecting to SSAS cube

Posted on 2010-11-25
7
1,367 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

760 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

19 Experts available now in Live!

Get 1:1 Help Now