Lesson 1: Deploying the Analysis Services Database

Typically, you will already have created and deployed your SQL Server Analysis Services database and built a cube before creating a report model; however, for the purposes of this tutorial, you will deploy the Analysis Services sample database that is included with SQL Server, 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

  1. On the computer where you installed SQL Server and the samples, navigate to:

    C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks Analysis Services Project\Enterprise

  2. In the Enterprise folder, double-click the Adventure Works.sln file.

    The SQL Server Business Intelligence Development Studio window opens with the contents of the file listed in Solution Explorer.

  3. In Solution Explorer, right-click AdventureWorks2008R2 DW, and then select Properties.

    The Adventure Works DW Property Pages dialog box opens.

  4. In the Configuration drop-down list, verify that Active(Development) is selected.

  5. In the Configuration Properties pane, click Deployment.

  6. In the Target Server box, verify that localhost is displayed.

  7. In the Target Database box, verify that Adventure Works DW is displayed.

  8. Click OK. 

  9. 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.