Date.Calendar in the Bottom
Axis panel. This opens the Member Selector and here the developer can choose the
individual years. Starting at the Year level makes the chart a bit more interesting, as
shown in Figure 6-12.
Allowing the designer to select members below the All level ahead of time is
useful, but imagine if someone asked that the report start at the month level for all
four years. Using the Member Selector, the developer would have to expand All
Periods, then each Year, each Half Year, and each Quarter just to get to the months,
Figure 6-11 A chart that shows a user has drilled down from a particular product line to
the countries that contributed to that particular item.
152 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
and then check each individual month. This would be a tedious process. Fortunately,
there is an easier way.
In the Member Selector, the developer can right-click on the All level and choose
to clear all selections, check the visible items, and so forth. The first item in the list,
however, allows the designer to automatically select all the members at a particular
level. Note that Figure 6-13 shows that the developer is selecting Month, which
really means that he or she is selecting all of the month members regardless of the
year in which they are found. This is a quick way to create to select many members
at a lower level of detail.
Multiple Dimensions on an Axis
So far, the examples have shown just a single dimension on the Series or Bottom
Axis.
Pages:
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214