PivotCharts can
even be created from data entered manually at the time the chart is created.
Unlike PivotCharts, PivotTables only have one active button, Commands and
Options, when first created. The Commands and Options button here is basically
a conglomeration of the Commands and Options and Chart Wizard options from
PivotCharts. This one button opens a dialog box that lets users connect to a data
source as well as change some properties of the grid.
Once a data source is chosen, the designer can choose to either select a single
table or cube, or to write a query that returns the desired records. After creating
a connection for a PivotChart, a Chart Field List appears that shows all of the
measures and all of the attribute hierarchies. In keeping with the previous examples,
a connection to the Adventure Works cube in Analysis Services would provide a list
like that shown in Figure 6-22.
Figure 6-21 Multiple dimensions are placed on both the rows and columns while a single
measure is in the background.
164 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
Note also in Figure 6-22 that there are many different types of charts available,
including bar, line, pie, area, and other chart types. Each chart type might have a
variety of subtypes available as well. This makes these charts far more flexible than
the Analytic Charts.
There are three areas on the chart onto which items can be dragged and dropped:
the chart itself, which is the only area on which measures can be placed; an area
for Series Fields (the Y-axis) 5; and an area for Category Fields (the X-axis).
Pages:
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226