Therefore,
background selections must be single members of the dimension.
Figure 6-43 showed that the selections made in the wizard were a measure of
Internet Sales Amount and a hierarchy called Customer Geography. Leaving all other
values set to the defaults and completing the wizard takes the user to a relatively
barren screen containing just a single box at the top, along with a small chart at
the bottom containing just a single bar. The box at the top is labeled All Customers
and shows a value of 29M and a percentage of 100. Hovering the mouse over this
box reveals additional details, such as the exact value. Clicking once on this box is
roughly analogous to expanding on a grid; the parent remains while the children are
now shown. In this case, the first level below the All level is Country, and there are
six countries that appear. The first country listed is the United States because it has
the largest value. The values are always shown sorted from highest to lowest. While
both the United States and Australia boxes show amounts of 9M, hovering over them
will display the actual values. In addition, the United States has a 32% in its box
while Australia has 31%. That means that the United States accounts for 32% of all
the sales of its parent, or in this case the All level.
Clicking on the box labeled Germany opens up the State-Province level, showing
the provinces of Germany. Hessen is the largest province in terms of the measure
called Internet Sales Amount.
Pages:
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253