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

eXerCISe 11-2. CONFIGUrING MeaSUreS prOpertIeS
aND reLatIONShIpS

in this exercise you begin configuring the cube you created in Exercise 11-1 using the first two tabs of the
cube designer.

Note: if you have closed the cube designer window since the previous exercise, please open it now.

Configure Cube Structure Tab

With the cube designer open, select the Cube Structure tab. Highlight the various measures and adjust their
properties. There are four main properties to choose from for each dimension. Please verify that the current
selection is correct, and if it is not, adjust it.

1. Change or validate the properties of the measure in the Fact Sales measure group.

You can do so by highlighting each object in the Measures pane and, if necessary,
changing the properties in accordance with those listed in Table 11-5 .

Table 11-5. Property Settings for the Fact Sales Measure Group

Object Property Value

Fact Sales measure group Name Sales

Sales Quantity measure Name SalesQuantity

AggregationFunction Sum

FormatString Standard

Visible True

Fact Sales Count measure Name NumberOfSales

AggregationFunction Count

FormatString Standard

Visible True

2. Change or validate the properties in the Fact Titles Authors measure group. You can

do so by highlighting each object in the measures pane and, if necessary, changing
the properties in accordance with those listed in Table 11-6 .