Creating and Configuring SSAS Cubes - Pro SQL Server 2012 BI Solutions - page 453

Table 11-6. Property Settings for the Fact Titles Authors Measure Group

Object Property Value

Fact Titles Authors measure group Name TitleAuthorInfo

Author Order measure Name AuthorListingOrder

AggregationFunction None

FormatString Standard

Visible False

Fact Titles Authors Count measure Name NumberOfAuthors

AggregationFunction Count

FormatString Standard

Visible False

Configure Dimension Usage Tab

Let's go to the Dimension Usage tab and change some of the relationship type settings.

1. Click the Dimension Usage tab and verify that it currently looks like Figure 11-23 .

2. Click the cell row named orderNumber. it is beneath the Sales column and alongside

Dimorders.

3. Click the ellipsis button when it appears (Figure 11-24 ), and the Define Relationship

dialog window will open.

4. in the Define Relationship dialog window, change the relationship type to Fact

(Figure 11-25 ).

5. Note how the diagram on the left side of this dialog window describes the relationships

between the dimensions and the measure groups using symbols (Figure 11-26 ).

Figure 11-26. Selecting a relationship type for the DimOrders dimension