M03D02 - SQL Server 2005 Reporting Services - Presentation

Gogula G. Aryalingam — Sun, 24 Jun 2007 22:43:07 GMT

Presentation from SQL Server 2005 Reporting Services by Joy Rathnayake, the first discussion from the June '07 meeting. PowerPoint 97-2003 version.

M03D01 - DW_How - Presentation

Gogula G. Aryalingam — Sun, 24 Jun 2007 22:38:51 GMT

Presentation from DW - How (A strightforward How-to on designing a data warehouse) by Gogula Aryalingam, the first discussion from the June '07 meeting. PowerPoint 97-2003 version and PowerPoint 2007 versions are included, along with Slide Notes explaining almost each slide.

M03D01 - DW_How - Sample

Gogula G. Aryalingam — Sun, 24 Jun 2007 22:23:51 GMT

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:

Download and extract the contents .zip file, to a folder of your choice.
Open SQL Server 2005 Management Studio
Connect to your SQL Server
Right click on the 'Databases' folder and select 'Attach...'
Click on the 'Add...' button in the 'Attach Databases' dialog box. This will open the 'Locate Database Files' dialog box.
Navigate to the folder which contains the extracted files and select 'WallaTile.mdf' and click on 'OK'.
Click on 'OK' again.
Follow the above steps again to attach the 'WallaTileDW.mdf' file.
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:

Start the SQL Server 2005 Analysis Services Deployment Wizard. Do this by going to Start -> Programs -> SQL Server 2005 -> Analysis Services -> Deployment Wizard
Click 'Next' on the Welcome screen
Click on ellipses (...) button to navigate to the WallaTileOLAP.asdatabase file in the extracted folder. Click on 'Next'.
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'.
In the 'Specify Options for Partitions and Roles' screen, click on 'Next' leaving the default options selected.
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.
In the connection manager, build a connection to the WallaTileDW database which was attached earlier.
Click on 'Test Connection', and if successful click on 'OK'. Click on Next.
In the 'Select Processing Options' screen select 'Full Processing' and click on 'Next'.
Click on 'Next' in the 'Confirm Deployment' screen.
The database will be deployed. Once done click on 'Next' and then on 'Finish'.

To view the OLAP cube, do the following:

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

Meeting 03 - Presentations & Samples

M03D02 - SQL Server 2005 Reporting Services - Presentation

M03D01 - DW_How - Presentation

M03D01 - DW_How - Sample