I've been working in Excel 2007, importing data from SSAS and I started getting this error when I try to connect to SSAS:
Data could not be retrieved from the database.
Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again.
I realize this isn't the Excel help board but was wondering if anyone else is seeing this? In regards to the message, I know that the SSAS is online and available - I can connect and browse the cube via Managaement Studio. This problem started happening after I processed the cube. I've stopped/started the SSAS service, closed/re-opened Excel and rebooted the SSAS machine and Excel still keeps giving that error.
Any help would be much appreciated.
When do you get the error? When creating a new connection in Excel? Or when opening an existing workbook?
It looks like the SSAS OLEDB provider might not be installed correctly. Try installing it (ASOLEDB9.msi) from http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
|||That download didn't fix the problem. I could use Excel 2007 to connect to SSAS just fine. I made some changes to the cube and re-processed it, THEN Excel 2007 stopped working. Previous connections in the workbook (to that re-processed cube) stopped working and I could not create new connections (to that re-processed cube). Any ideas welcome...|||Still having the problem, however I tried something on a whim and wanted to post it here. I had a hunch that the KPIs in the cube may be causing the problems so I removed them and re-processed the cube. Tried to connect with Excel 2007 and it worked. Added the KPIs back and I get the "cannot connect" error message I originally posted. Seems like an issue to me.
No comments:
Post a Comment