Figure 5-26 shows an example of an Analytic Chart showing the order quantity
for eight quarters. The Order Quantity measure has been placed in the Series panel.
The Date.Calendar hierarchy has been added to the Bottom Axis panel. After adding
the hierarchy, the members have to be selected by the designer. Otherwise only the
default member is chosen, which is usually the All member. In order to choose the
individual members, developers can right-click on the dimension in the Bottom Axis
panel and choose Select Members or click the drop-down indicator to the right of
the hierarchy. Either will open up a dialog box which lets the developer expand the
Figure 5-26 An Analytic Chart showing the Date dimension on the bottom axis and the
Order Quantity as the series
C h a p t e r 5 : M o n i t o r i n g i n P e r f o r m a n c e P o i n t S e r v e r 119
various levels of the hierarchy and select any members desired. In this case, the four
quarters from each year of 2002 and 2003 were chosen.
Notice that nothing is currently in the Background panel. By default, all
dimensions are always involved in a query, but they typically are defaulted to the All
level so they don??™t filter the data in any way by default. There are times that reports
will need to be filtered by data that is not otherwise displayed as part of the chart or
grid. For example, this report could have its name changed to Bikes Quantity Sold
and the data could be filtered by bikes. To do this, the Product.
Pages:
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176