Skip to content

Instantly share code, notes, and snippets.

@yancyn

yancyn/AdventureWorkDW2014-Cube.md

Created March 21, 2017 11:01
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yancyn/0721da513bb2c3975a3352af4ef3537c to your computer and use it in GitHub Desktop.
Save yancyn/0721da513bb2c3975a3352af4ef3537c to your computer and use it in GitHub Desktop.
Download ZIP
Install AdventureWork Data Warehouse 2014
Raw
AdventureWorkDW2014-Cube.md

Install AdventureWork Data Warehouse 2014

Create AdventureWorkDW Database

  1. Download Adventure Works 2014 Warehouse Script.zip.
  2. Unzip to C:\Program Files\Microsoft SQL Server\120\Tools\Samples\Adventure Works 2014 Warehouse Script\
  3. SQL Management Studio > Connect to MSSQL Server > Run instawdbdw.sql.

Deploy Cube

  1. Download AW Multidimensional Models SQL Server 2014.zip
  2. Open solution AWDW2014Multidimensional-EE.sln in SQL Server Data Tools (Visual Studio).
  3. 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.
  1. Right click project > Deploy > Set server and cube name.
  2. Deploy.

see Readme for Adventure Works DW 2014 Multidimensional Databases.docx

@technologyhamed
Copy link

OK

@Vikas-jk
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment