Lesson 13: Creating a Perspective
For models that contain many subject areas, for example, Sales, Manufacturing, and Supply data, it might be helpful to Report Builder users if you create perspectives of the model. A perspective is a sub-set of a model. Creating perspectives can make navigating through the contents of the model easier for your model users. In this lesson, you will create a perspective and add the entities that you want to the perspective. In addition, you will view your changes in Report Builder.
To create a perspective
In the Tree view, right-click Model, point to New, and then click Perspective.
In the Edit Perspective dialog box, click Clear All.
Locate the Purchase Order Detail entity, and then select its check box.
Notice that the Purchase Order Header and Product check boxes are selected but grayed out. If you clicked OK now, only the identifying attributes would be added to the perspective. For the purpose of this exercise, you are adding the entire contents of both entities to the perspective.
To add all the attributes of the Purchase Order Header entity to the perspective, clear the check box, and then select the check box again.
Locate the Product entity, clear the check box, and then select the check box again.
Click OK.
Your new perspective contains the Product and Purchase Orders entities and a few related roles and entities.
To rename the perspective
To see the new perspective, scroll down to the bottom of the List view.
The last item listed is called NewPerspective.
Right-click NewPerspective, and then click Rename.
Type Products and Purchases.
On the File menu, click Save All.
To deploy the report model
- On the Build menu, click Deploy AdventureWorks Model.
To view report model changes in Report Builder
Launch Report Builder.
In the Getting Started pane, locate the AdventureWorks model.
Notice that there is a new plus (+) symbol next to the AdventureWorks model.
To view the perspective that you created, click the plus symbol.
Select Products and Purchases.
Click OK.
When the Explorer pane appears, notice that the Product, Purchase Order Detail, and Purchase Order Header entities are listed.
Drag the Product entity to the design area.
In the Entities list, select Purchase Order Details.
In the Fields list, select Total Received Qty and drag the field to the right of the Name field.
In the Fields list, notice that Sum Fulfilled Qty and Fulfilled Qty are listed at the bottom of the list for the Purchase Order Details entity. Note that your Sum Fulfilled Qty is shown at the top level with Fulfilled Qty nested below it.
In the Fields list, select Sum Fulfilled Qty and drag the field to the right of the Total Received Qty field.
On the Report toolbar, click Run Report.
As you move your mouse pointer around the report, notice that it changes shape. You can click on any content in the Name, Total Received Qty, or Sum Fulfilled Qty columns.
In the Sum Fulfilled Qty column, click 147.00 for the Bearing Ball row.
The Purchase Order Details clickthrough report appears. Note that the second Modified Data column no longer appears and that the Received Qty and Rejected Qty fields are added.
Next Steps
Congratulations, you have successfully completed the Refining a Report Model in Model Designer tutorial.