

For information about configuring the EffectiveUserName feature for OLAP data sources, see Use Analysis Services EffectiveUserName in SharePoint Server. For information about configuring Secure Store, see Plan the Secure Store Service in SharePoint Server and Configure the Secure Store Service in SharePoint Server. It is assumed that one or more of these options are configured on your farm. When using Excel Services or PerformancePoint Services, user access can be provided using Windows Authentication with Kerberos delegation, the Secure Store Service, or, with OLAP data sources, the EffectiveUserName feature. For information about deploying Excel Services, see Overview of Excel Services in SharePoint Server 2013 and Configure Excel Services in SharePoint Server 2013. It is assumed that these are configured on your farm. The subsequent articles make use of Excel Services and PerformancePoint Services. To create a Business Intelligence Center, you must be a farm administrator on the SharePoint Server 2013 farm. To deploy the AdventureWorks sample data, you must be a SQL Server and Analysis Services administrator.

Before you beginīefore starting, read the following information about permissions and software requirements:

The procedures for completing both of these tasks, plus procedures for configuring the required user access and permissions are included in this article. Installing the AdventureWorks sample data set consists of downloading the sample data, attaching the sample databases in SQL Server Management Studio, and deploying the sample OLAP cube using the SQL Server Data Tools.Ĭreating a Business Intelligence Center consists of creating a new site collection with the Business Intelligence Center template using the SharePoint Central Administration website. This scenario applies only to SharePoint Server 2013 Enterprise.
