Lesson 1: Deploying the Analysis Services Database
New: 5 December 2005
Typically, you will already have created and deployed your SQL Server Analysis Services (SSAS) database and built a cube before creating a report model; however, for the purposes of this tutorial, you will deploy the SSAS sample database that is included with SQL Server 2005, which already contains a cube, and then create your SSAS cube-based report model. In this lesson, you will install the SSAS sample database and then deploy it. If you have already installed an SSAS cube on the server where you want to build your model, then proceed to Lesson 2: Creating a Report Model Using Report Manager.
To deploy the Analysis Services sample database
On the computer where you installed SQL Server 2005 and the samples, navigate to:
C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Enterprise
In the Enterprise folder, double-click the Adventure Works.sln file.
The SQL Server 2005 Business Intelligence Development Studio window opens with the contents of the file listed in Solution Explorer.
In Solution Explorer, right-click Adventure Works DW, and then select Properties.
The Adventure Works DW Property Pages dialog box opens.
In the Configuration drop-down list, verify that Active(Development) is selected.
In the Configuration Properties pane, click Deployment.
In the Target Server box, verify that localhost is displayed.
In the Target Database box, verify that Adventure Works DW is displayed.
Click OK.
On the Build menu, select Deploy Adventure Works DW.
When the Analysis Services database is deployed, a status message appears indicating whether deployment was successful or not. If deployment was not successful, review the Error List to determine what is the problem. To view the Error List pane, on the View menu, select Error List. Otherwise, you are ready to create a model based on the AS cube.
Next Steps
Now that the SSAS database has been deployed, you can create a report model based on the cube. In the next lesson, you will create a report model using Report Manager. See Lesson 2: Creating a Report Model Using Report Manager.
See Also
Concepts
SQL Server 2005 Analysis Services Tutorial
Other Resources
Developing Analysis Services Solutions and Projects
Introducing Business Intelligence Development Studio