Excel 2007 and SSAS 2008 Error
User Rating: / 4
PoorBest 
Written by Alex Whittles   
Friday, 30 October 2009 22:19

I was working on a new SSAS 2008 cube today, and came across an error which Google was unable to help with. I thought I’d post the solution here to help anyone else who may encounter it.

The cube in question will be primarily be accessed using Excel 2007, so I’d been dutifully testing it along the way to ensure all was well. And then, after a number of changes the following error appeared when connecting to the cube from Excel to create a pivot table.

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

Read more...

 
Comments (5)
5 Friday, 18 November 2011 10:34
M.Solcia
I'm here again.
Now the link is work, but now it's wrong.
In order to find the correct page, use the following:

http://www.purplefrogsystems.com/blog/?s=Excel+2007+and+SSAS+2008+Error+&search=Search
4 Wednesday, 19 January 2011 14:05
G2011reb
During our development we found out that if the mdx cube script definies named sets that are very performance intensive to generate - this will considerably slow down the loading of the cube in Excel 2007.

we also a few times received the error message:

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

but after removing the named sets from the mdx cube script we were able to open the cube in Excel 2007
3 Friday, 22 January 2010 17:32
Vidas M.
M.Solcia,

I believe this was very temporary problem. I experienced it too, but few minutes later their server was back online and link worked. Please try again.
2 Friday, 22 January 2010 17:27
M.Solcia
The link "read more" doesn't work. Web page returns "Database Error". Is there a mirror link?

Thanks in advance
1 Tuesday, 03 November 2009 10:11
F.Leeuwerck
Thanks for sharing, indeed a hard to troubleshoot situation.

Tags: article, excel
 

Pyramid Analytics