[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel 2003 & Windows 7 error when connecting to SSAS cube

Posted on 2010-11-25
7
Medium Priority
?
1,414 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
[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
  • 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

656 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