|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.