How to Configure Microsoft SharePoint for Analytics


Updated: May 13, 2016

Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager

Microsoft SharePoint 2010 not only stores Excel workbooks that contain Service Manager Microsoft Online Analytical Processing (OLAP) data cubes in document libraries, but it is also used to render Excel workbooks with the use of a web browser. Using SharePoint makes it possible for Service Manager users that do not have Excel to get access to the information they need. It also enables quick and easy access from mobile devices.


You must already have Microsoft SharePoint 2010 for Internet Sites Enterprise installed to perform this procedure.

To enable Excel Services on SharePoint 2010

  1. Click Start, and then click SharePoint 2010 Central Administration.

  2. Under System Settings, click Manage farm features.

  3. Ensure that both the Excel Services Application View Farm Feature and Excel Services Application Web Part Farm Feature are set to Active. If they are not set to Active, click Activate.

See Also

Managing the Data Warehouse in System Center 2012 - Service Manager