| Excel 2007 and SSAS 2008 Error |
| 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. |
Comments (5)
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
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
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.
Thanks in advance