Share via

  • Article

Creating an Analysis Services Project (Basic Data Mining Tutorial)

Each Microsoft SQL Server Analysis Services project defines the schema for the objects in a single Analysis Services database. An Analysis Services database contains mining structures and mining models, Online Analytical Processing (OLAP) cubes, and supplemental objects such as data sources and data source views. In this tutorial we will be using the AdventureWorksDW2008 database.

By default, Analysis Services uses the localhost instance for new projects. If you are using a named instance or a different server, you must first create and open the project and then change the instance name.

For more information about Analysis Services projects, see Creating an Analysis Services Project.

To create an Analysis Services project

  1. Open Business Intelligence Development Studio.

  2. On the File menu, point to New, and then select Project.

  3. Verify that Business Intelligence Projects is selected in the Project types pane.

  4. Verify that Analysis Services Project is selected in the Templates pane.

  5. In the Name box, name the new project ASDataMining2008.

  6. Click OK.

To change the instance where data mining objects are stored

  1. In Business Intelligence Development Studio, on the Project menu, select Properties.

  2. On the left side of the Property Pages pane, under Configuration Properties, click Deployment.

  3. On the right side of the Property Pages pane, under Target, verify that the Server name is localhost. If you are using a different instance, type the name of the instance. Click OK.