- Download Adventure Works 2014 Warehouse Script.zip.
- Unzip to C:\Program Files\Microsoft SQL Server\120\Tools\Samples\Adventure Works 2014 Warehouse Script\
- SQL Management Studio > Connect to MSSQL Server > Run instawdbdw.sql.
- Download AW Multidimensional Models SQL Server 2014.zip
- Open solution AWDW2014Multidimensional-EE.sln in SQL Server Data Tools (Visual Studio).
- Modify AdventureWorksDW2014.ds to using your local settings.
- Connect to the server where you create AdventureWorkDW and point to AdventureWorkDW database by test connectstring.
- Enter impersonation information as appropriate.
- Right click project > Deploy > Set server and cube name.
- Deploy.
see Readme for Adventure Works DW 2014 Multidimensional Databases.docx
Thanks, if anyone stumbles upon this and want to restore adventureworks database in SQL server check
Download and restore adventureworks database in SQL server
thanks