Install AdventureWork Data Warehouse 2014

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s