[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1423
  • Last Modified:

Excel 2003 & Windows 7 error when connecting to SSAS cube

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
PitcherICT
Asked:
PitcherICT
  • 5
  • 2
1 Solution
 
CSLARSENCommented:
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
 
PitcherICTAuthor Commented:
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
 
CSLARSENCommented:
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 free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
PitcherICTAuthor Commented:
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
 
PitcherICTAuthor Commented:
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
 
PitcherICTAuthor Commented:
correct
0
 
PitcherICTAuthor Commented:
Tested and agreed
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now