My findings and self-taught lessons in ETL, OLAP, and Business Intelligence
Monday, May 4, 2009
HOW TO: Query SSAS 2008 Cube via Excel 2003
I searched high and low for this information and could not find it anywhere. I finally by chance figured it out in reading a few different forum posts on unrelated issues. I figured someone should post it somewhere.
To connect with an Analysis Services 2008 cube in Excel 2003, you will need the Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider:
The standard connector that comes with Excel 2003 will not work with SSAS 2008. Though I would highly recommend an upgrade to Excel 2007 if you will be doing a lot of work with SSAS.
I have loaded both the MS SQL Server '08 Analysis Services 10.0 OLE DB provider and the Core XML Services 6.0, but my end users are not seeing 10.0 when trying to connect in Excel '03. What am I missing? Help please.
Honestly I am not sure - I'd recommend posting at http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads - I get a lot of help there.
I have loaded both the MS SQL Server '08 Analysis Services 10.0 OLE DB provider and the Core XML Services 6.0, but my end users are not seeing 10.0 when trying to connect in Excel '03. What am I missing? Help please.
ReplyDeleteHonestly I am not sure - I'd recommend posting at http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads - I get a lot of help there.
ReplyDelete