Tuesday, October 28, 2008

Problems connecting to SSAS 2005 from Excel 2003

Today I was trying to connect to SSAS 2005 cube from Excel 2003 and I was not able to do so using the exisitng OLAP 8.0.

I had to download the folowing to resolve the problem.

1. Microsoft Core XML Services (MSXML) 6.0 SP1
2. Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

I have followed the article on Microsoft downloads http://support.microsoft.com/kb/940167

and that solved my problem !

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...