There is a caveat when placing multiple items from the same dimension in the
background. While measures are not technically in a measures dimension, they
are often treated as if Measures is a dimension (in fact, it is often referred to as the
Figure 6-18 The Sales Territory dimension now has multiple members selected for it in the
background and the individual items are listed in the information area of the
report.
C h a p t e r 6 : A n a l y s i s w i t h P e r f o r m a n c e P o i n t S e r v e r a n d P r o C l a r i t y 159
???Measures dimension???). However, placing more than one measure in the background
is not allowed. Attempting to place two measures in the Background panel will cause
the Dashboard Designer to move both measures to the Bottom Axis by default. If
the developer attempts to move just one of the measures, both will move as a single
unit. While it often makes sense to sum up members such as Canada and the United
Kingdom for a single measure, adding up disparate measures doesn??™t make sense.
Therefore, the Dashboard Designer will not allow multiple measures in the background.
Understanding how items work in the background is important for developers
creating reports, but it is not always the best way to create reports for end users.
Recall from Chapter 5 that a dashboard can have one or more filters on it. Allowing
users to select items from drop-down lists is often the best way to implement the
ability for users to choose the countries, products, measures, and other items they
wish to see.
Pages:
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220