You can deploy Analysis Services and Reporting Services as shared services in a SharePoint farm. Deploying Analysis Services and Reporting Services enables you to use features such as PowerPivot for Microsoft SharePoint and Power View, a Reporting Services interactive report designer.
To deploy Reporting Services, Power View, and PowerPivot for SharePoint, you must install the following products:
■ SharePoint Server 2010 Enterprise edition with Service Pack 1
■ SQL Server 2012 Database Engine
■ SQL Server 2012 Reporting Services and Reporting Services Add-in
■ SQL Server 2012 PowerPivot for SharePoint
The host computer must be joined to the domain, and you must configure domain user accounts for the following services:
■ SharePoint Web Services and Administrative Services
■ Reporting Services
■ Analysis Services
■ Microsoft Excel Services
■ Secure Store Services
■ PowerPivot System Service
The SQL Server 2012 Database Engine can use a Virtual or Managed service account. To configure SharePoint 2010 and SQL Server 2012 integration, perform the following general steps:
- Install a SharePoint Server 2010 SP1 Enterprise edition farm. Choose to configure the farm later by not running the SharePoint 2010 Product Configuration Wizard. This enables you to use the SQL Server 2012 Database Engine as the farm’s database server.
- Install the SQL Server 2012 Database Engine and PowerPivot for SharePoint, as shown in Figure 3-5.
FIGURE 3-5 Install SQL Server PowerPivot for SharePoint
- Accept the default instance ID of PowerPivot and complete the SQL Server 2012 Installation Wizard.
- Use the PowerPivot Configuration tool, available from the Configuration Tools folder and shown in Figure 3-6, to create the farm, a default web application, and a root site collection.
FIGURE 3-6 PowerPivot Configuration Tool
- Verify that the farm is operational by navigating to Central Administration.
- Run SQL Server 2012 setup again to install and configure Reporting Services and the Reporting Services Add-in.
- SharePoint Site Administrators can extend SharePoint document libraries to use Business Intelligence (BI) content types. This can be done by performing the following steps:
a) In Shared Documents or another document library, on the Library tab, click Library Settings. Under General Settings, click Advanced Settings. In Content Types, click Yes to enable management of content types.
b)On the Library tab, click Library Settings. Under Content Types, click Add From Existing Site Content Types. Locate the Business Intelligence content type group and add BI Semantic Model Connection File and Report Data Source.
- SharePoint Site Administrators create data connection files to launch Power View.
This involves creating a BI semantic model connection (.bism) or a Reporting Services shared data source (.rsds) as a data source for Power View.