- Adventureworks2012 tests software#
- Adventureworks2012 tests plus#
- Adventureworks2012 tests download#
- Adventureworks2012 tests windows#
The AdventureWorksDW2012 database must be deployed on the SQL Server database engine as covered in the section above. Procedures are provided to accomplish each of these tasks if they have not already been completed in your environment. The following requirements must be met before you can deploy the sample OLAP cube.
Under "AdventureWorksDW2012" database details, select the row where File Type is Log.ĭeploy the AdventureWorks sample OLAP cube Navigate to the location where you copied AdventureWorksDW2012_Data.mdf, select the file, and then click OK. To deploy the AdventureWorksDW2012 data warehouseĬopy AdventureWorksDW2012_Data.mdf to your default database directory (normally \Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA) or other location as designated by your database administrator.
Adventureworks2012 tests download#
Use the following procedure to download and deploy the AdventureWorksDW2012 data warehouse database. Under "AdventureWorks2012" database details, select the row where File Type is Log. Navigate to the location where you copied AdventureWorks2012_Data.mdf, select the file, and then click OK. On the Attach Databases dialog, click Add. Right-click Databases, and then click Attach. (If the Unblock button is not present, then the file is not blocked.)Ĭopy AdventureWorks2012_Data.mdf to your default database directory (normally \Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA) or other location as designated by your database administrator.
Click the Unblock button if it is present, and then click OK. Right-click the file, and then click Properties.
Video: Configure AdventureWorks for Business Intelligence solutionsīecause this file was downloaded from the Internet, it may be blocked by Windows. This video shows the steps involved in installing and configuring the AdventureWorks sample data set, as described in this article. 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.
Adventureworks2012 tests windows#
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.
Adventureworks2012 tests software#
Before you beginīefore starting, read the following information about permissions and software requirements:
Adventureworks2012 tests plus#
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.
0 kommentar(er)
