Lesson 1: Creating a New Report Model Project

In this tutorial, you will create a report model project called ModelTutorial using Business Intelligence Development Studio. In order to create reports in Report Builder, at least one model needs to be available. A report model project contains the definition of the data source (a .ds file), the definition of a data source view (a .dsv file), and the model (an .smdl file).

To create a new report model project

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, and then click Business Intelligence Development Studio.

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

  3. In the Templates list, click Report Model Project.

  4. In the Name, type ModelTutorial.

  5. To create the model project, click OK.

    The ModelTutorial solution is displayed in Solution Explorer.

Next, you will create a data source for your model. See Lesson 2: Defining a Data Source for Your Report Model.