Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

VI.3.2. Easy Integration with Business Intelligence Development Studio

To get a good feel for what a SQL Server Analysis Services (SSAS) project looks like within SSMS, you need to build and deploy a project from within BIDS. We cover BIDS in depth in the previous chapter; however, the following steps guide you through the basics of how to get an application into SSAS that you can explore.

For this procedure, you need the following installed:

• SQL Server Database Services: A typical SQL Server installation allows you to add the AdventureWorks DW2008 file.

• SQL Server Analysis Services: After the cubes and data mining structures are built, you deploy them to SQL Server Analysis Services.

• AdventureWorks DW BI 2008 file: This file includes the AdventureWorksDW2008 database and can be obtained from this page:

  www.codeplex.com/MSFTDBProdSamples

  On the Microsoft CodePlex site, click the Releases tab to access the AdventureWorksDWBI2008 file. After downloading the file, double-click it to launch the installation wizard and install the AdventureWorksDW2008 database on your SQL Server system. You should be able to see this database when connected to SQL Server in SQL Server Management Studio.

If you have the prerequisite files, follow these steps to build and deploy a SQL Server Analysis project that already has most of what you need. You browse to the project and launch BIDS by double-clicking the solution file. From within BIDS, you build and deploy the project.

1. Launch the Business Intelligence ...