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 !
Did you know that you could export data from different SSRS Tablix into different excel sheets of a workbook?
Today I had a requirement from one of my customer to export data from two different tables generated out of SSRS reports into two different...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...