Sample from DW - How (A strightforward How-to on designing a data warehouse) by Gogula Aryalingam, the first discussion from the June '07 meeting. Instructions for setting up the sample is given below:

1. Download and extract the contents .zip file, to a folder of your choice.
2. Open SQL Server 2005 Management Studio
3. Connect to your SQL Server
4. Right click on the 'Databases' folder and select 'Attach...'
5. Click on the 'Add...' button in the 'Attach Databases' dialog box. This will open the 'Locate Database Files' dialog box.
6. Navigate to the folder which contains the extracted files and select 'WallaTile.mdf' and click on 'OK'.
   Click on 'OK' again.
7. Follow the above steps again to attach the 'WallaTileDW.mdf' file.
8. Now you have bot the WallaTile database and the WallaTileDW data warehouse, which can be used for reference when following the PowerPoint presentation.

In order to attach the WallaTile OLAP database, you would need SQL Server 2005 Analysis Services installed. This OLAP database also requires that the WallaTileDW database be attached to SQL Server as well. Follow these steps to attach the OLAP database:

1. Start the SQL Server 2005 Analysis Services Deployment Wizard. Do this by going to Start -> Programs -> SQL Server 2005 -> Analysis Services -> Deployment Wizard
2. Click 'Next' on the Welcome screen
3. Click on ellipses (...) button to navigate to the WallaTileOLAP.asdatabase file in the extracted folder. Click on 'Next'.
4. Type the name of your SQL Server 2005 Analysis Server in the 'Server:' textbox while leaving the 'Database:' drop down box as it is. Click on  'Next'.
5. In the 'Specify Options for Partitions and Roles' screen, click on 'Next' leaving the default options selected.
6. In the 'Specify Configuration Properties' screen click on the ellipses (...) button next under 'Data Source Connection Strings' next to 'WallaTile Datawarehouse'. The 'Connection Manager' dialog box opens up.
7. In the connection manager, build a connection to the WallaTileDW database which was attached earlier.
8. Click on 'Test Connection', and if successful click on 'OK'. Click on Next.
9. In the 'Select Processing Options' screen select 'Full Processing' and click on 'Next'.
10. Click on 'Next' in the 'Confirm Deployment' screen.
11. The database will be deployed. Once done click on 'Next' and then on 'Finish'.

To view the OLAP cube, do the following:

1. In the SQL Server Management Studio, connect to your Analysis Server.
2. Expand the 'Databases' folder. You will find the 'WallaTileOLAP' database. Expand it.
3. Expand the 'Cubes' folder.
4. You will find one cube named 'Sales'.
5. Right-click on the Sales cube and click on 'Browse'.