Setting up Adventureworks[AW] Datawarehouse[DW] Database as a Project Source for Microstrategy Projects.

The next step is to import the AW-DW Database into Microstrategy.

Pre-requisite 

1. Microsoft SQL Server 2008 R2 is installed
2. Microstrategy is installed and configured
3. Have Admin privileges on SQL Server and Microstrategy Boxes.

Installing Microsoft Adventureworks datawarehouse database.

Step 1: - Download Microsoft AdventureworksDW2008R2_Data.mdf file from 
below link

http://msftdbprodsamples.codeplex.com/downloads/get/363848

Step 2:- Login to MS SQL Server with Admin privileges and attach the mdf file
without the log file by placing the downloaded mdf file in the location path
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA
and run this below script in the SQL Server and Execute it.

EXEC sp_attach_single_file_db @dbname='AdventureWorksDW2008R2_Data',
@physname=N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2008R2_Data.mdf'
GO

This should attach the database without the log file.


Now Microsoft Adventure works database is ready as a source database for Microstrategy Projects.

Adventure Works Datawarehouse Data Model 

Download the Datamodel for Adventureworks Datawarehouse Database by Right click and save the below picture.

This can be used as a reference to create a Logical Data Model for our Microstrategy Project.