Section 6.3. Create a Report Model

6.3. Create a Report Model

To define a new report modela metadata abstraction of the underlying database that identifies business entities, fields, and rolesfollow these steps:

1. Right-click on the Report Models node in the Solution Explorer pane and select Add New Report Model from the context menu to launch the Report Model Wizard.

2. If the Welcome dialog for the Report Model Wizard appears, click the Next > button.

3. Select the Adventure Works.dsv data source view in the Select Data Source View dialog as shown in the following figure.

   Figure 6-6. Report Model Wizard: Select Data Source View

   

4. Click the Next > button to open the Select report model generation rules dialog shown in the following figure.

   Figure 6-7. Report Model Wizard: Select Report Model Generation Rules

   

5. Accept the defaults and click the Next > button to display the Collect Model Statistics dialog shown in the following figure.

   Figure 6-8. Report Model Wizard: Collect Model Statistics

   

6. Accept the dialog defaults and click the Next > button to display the Completing the Wizard dialog shown in the following figure.

   Figure 6-9. Report Model Wizard: Completing the Wizard

   

7. Click the Run button to create the new report model. The dialog displays metadata rules for the report model in the Status list box, and a Finish button (in place of the Run button).

8. Click the Finish button after processing completes to end the wizard.

The new report model Adventure Works.smdl appears in the Solution Explorer pane under the Report Models node.