Solved

Excel 2003 & Windows 7 error when connecting to SSAS cube

Posted on 2010-11-25
7
1,384 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
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

730 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