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 !

2 comments:

the engineer said...

hi you have good blog

can you add my blog as friend blog and me too

thanks

Hapi said...

Hello.. Do you know how to Add Adsense Code Inside Single Post Only in XML Template? Visit your blog to learn how.. Have a nice thursday!

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