Install AdventureWork Data Warehouse 2014

Install AdventureWork Data Warehouse 2014

Create AdventureWorkDW Database

  1. Download Adventure Works 2014 Warehouse
  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
  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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s