Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

126

❘

LESSON 14 Editing Your dimEnsion

select the Date attribute and then change Type to Date (as shown in

Figure 14-9). Change the Year attribute to Years, Quarter to

QuarterOfYear, and Month to MonthOfQuarter.

TRY IT

You’ve learned in this lesson how to modify a dimension for perfor-

mance and for usability. In this Try It, you’re going to modify the Sales

Territory dimension that was created in the last lesson to add a user

hierarchy and add the necessary attribute relationships.

Lesson Requirements

To complete this lesson, first, modify the Sales Territory.dim file to add a new hierarchy with the

following levels: Sales Territory Group → Sales Territory Country → Sales Territory Region. You

will also want to create the attribute relationships to optimize the dimension. Last, hide the Sales

Territory Key attribute to prevent users from dragging it over.

Hints

The attribute relationship should be created in the Attribute Relationship tab and should

 ➤

look like Sales Territory Key → Sales Territory Region → Sales Territory Country → Sales

Territory Group.

Step-by-Step

1. Double-click the Sales Territory.dim file from the Solution Explorer.

2. In the Dimension Structure tab of the dimension editor, drag the Sales Territory Group, Sales

Territory Country, and Sales Territory Region columns from the Data Source View pane to

the Attributes pane.

3. Drag the same attributes into the Hierarchies ...