Importing Adventure Works sample database into your SQL environment can come in real handy when you need some sample data to demo some of the SharePoint BI capabilities. I used Adventure Works SSAS cube sample data to create interactive analytic charts and reports using Performance Point Services and users were ecstatic when they saw what BI capabilities SharePoint can provide.I drafted this post just to show you how easily you can import the database into your SQL 2012 environment.Downloads.-.-.- SQL Server 2012 with Analysis Services deployedSteps1) Download the Adventure Works DW 2012 and attach it to your SQL instance.2) Download the Analysis Services Project and open the project in visual studio / Business Intelligence Development studio.
I have installed SQL Server 2005 with Database Engine and Analysis Services both utilizing the DEFAULT instance. I also installed all the sample databases from the Advanced option. When I connect to Database Engine, I can see both 'Adventure Works' and 'Adventure Works DW' databases. Hi, You need to manually build and deploy via business. May 19, 2013 SQl Server 2012 AdventureWorksDW database ATTACH. SQL Server Analysis Services https. It has worked for me. Nice link to download for Adventure. Friday, October 28.
![Works Works](http://c3154802.r2.cf0.rackcdn.com/article_images/backup_ssas_database_files/image001.jpg)
As the project was built on previous version of studio, you will need to upgrade it to new solution but that would be smooth as well.3) Open the upgraded project4) Make sure the user has been granted dbreader and dbwriter permissions on Adventure Works DW database imported in step 1.5) Right click Adventure Works data source file, select Open and then Edit connection. Choose connection provider and select the imported AdventureWorksDW database. Make sure to test the connection.6) Right click Project - Go to Properties - Select Deployment. Configure the Server and Database parameters to point to correct database.7) Right click the solution and click Deploy. This will deploy the analysis services cubes into your 2012 environment., Post navigation.