SharePoint 2003 and SSAS 2005 cubes

Tue, 23 Jun 2009 20:34:58 Z

I have SharePoint Portal Server 2003 (with WSS 2.0) with MS Office 2003 installed only and the Data Cube available is built with SQL Server 2005 Analysis Services.

Are all those systems and applications compatible with each other? If not, what needs to be done other than the obvious solution of upgrading MS Office, SharePoint, and WSS?

There is a previous post http://social.msdn.microsoft.com/Forums/en-US/sharepointbi/thread/ca05ed06-7e22-4136-ac15-d76d198a5622 but I don´t see an answer that fits my needs. Aren´t SSRS matrix reports static? Can I pivot these reports?

I searched for the SQL Server 2005 drivers but they can´t be installed in SharePoint 2003, they are for SharePoint 2007 http://www.microsoft.com/downloads/details.aspx?FamilyId=1e53f882-0c16-4847-b331-132274ae8c84&DisplayLang=en

I have Office 2003 on the clients but we are looking for a web solution.

Thanks in advance,

Miguelangel

SharePoint 2003 and SSAS 2005 cubes

Tue, 30 Jun 2009 07:40:19 Z

Hi You can create OWC Reports. You can use either front page or sharepoint designer and add OWC Control.(This is an activex control).You can use the pivot table control and connect the same to the cube . Deploy this webpage into a virtual directory. Use Page Viewer web part to call the page when you want to display a pivot table report.
This report can be exported to Excel also from the web.

SSRS Reports are static.

SharePoint 2003 and SSAS 2005 cubes

Thu, 02 Jul 2009 12:56:36 Z

OK, Thanks Hemanth.