Sharepoint List with Analysis Services

Question

Hi
I want to ask that is there any way to integerate sharepoint list with analysis services.
i have few list i want to build analysis report using anlysis services but sharepoint list will be the datasource

Answer 1

Hi Umer Jamil,

 

Analysis Services requires Microsoft SharePoint Server 2010 for its SharePoint integration feature, named Microsoft SQL Server PowerPivot for SharePoint. You can deploy both PowerPivot for SharePoint and Reporting Services in the same SharePoint farm if you are using SharePoint Server 2010.

 

Reporting Services can run on a broader range of SharePoint products and technologies than Analysis Services. You can deploy a report server in any standalone SharePoint server or server farm that is based on Windows SharePoint Services 3.0 or later, or Microsoft Office SharePoint Server 2007 or later.

 

For more information, please refer to:

http://msdn.microsoft.com/en-us/library/ee210689(SQL.105).aspx

http://msdn.microsoft.com/en-us/library/ee210649(SQL.105).aspx

 

Hope this helps.

 

Lu Zou