Export (0) Print
Expand All

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.

ms345301.note(en-US,SQL.90).gifNote:
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.

  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.

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.

ms345301.note(en-US,SQL.90).gifNote:
In Lesson 8, you will validate the changes you made to the model in Lessons 2 through 8.

Community Additions

ADD
Show:
© 2014 Microsoft