Lesson 2: Adding a Description to a Model

New: 5 December 2005

In the previous lesson, you created and deployed a report model, and then tested the model in Report Builder. In this lesson, you will add a description to the report model. A description is a brief explanation of the contents of the model, which appears in the Getting Started pane of Report Builder. When users select your model, the description appears below it and allows users to determine whether they want to use this model to build their reports.

In addition, you can create descriptions for entities, attributes (fields in Report Builder), and roles that provide interesting information that the user might want to know. Report Builder users see these descriptions as tool tips when they hover the pointer over an item in the Explorer pane.

Note

The following procedure assumes that you did not close the Business Intelligence Development Studio window that was open in the previous lesson. To open the AdventuresWorks project in Business Intelligence Development Studio, click Start, point to All Programs, point to Microsoft SQL Server 2005, click SQL Server Business Intelligence Studio. In the Recent Projects pane, click Open Project, select the AdventureWorks.sln file, and then click OK.

To add a description to a report model

  1. Return to the AdventureWorks report model project open in the Business Intelligence Development Studio window.

  2. In the Tree view, select the Model node.

  3. In the Properties window, locate the Description property.

  4. In the Description box, type the following: This report model is for the AdventureWorks database.

  5. In the Tree view, select the Sales Person entity, and then type the following in the Description box: All sales people are employees.

  6. In the List view, select the Sales Quota attribute, and then type the following in the Description box: Sales quotas are updated quarterly.

  7. On the File menu, click Save All.

Next Steps

You have successfully added descriptions for the model and for an entity and attribute. In the next lesson, you will organize the model by adding a folder to the model. See Lesson 3: Organizing a Model Using a Folder.

Note

In Lesson 8, you will validate the changes you made to the model in Lessons 2 through 8.

See Also

Tasks

Tutorial: Refining a Report Model in Model Designer

Concepts

Reporting Services Tutorials

Other Resources

SemanticModel Object (Model Designer)
Model Designer Object Properties

Help and Information

Getting SQL Server 2005 Assistance