The user can still expand or drill down on members of either products or
sales territories to perform analysis. Figure 6-21 shows an example of a user having
expanded both the All Products and the All Sales Territories members one time (as
well as expanding All Periods.) Note that the first set of rows has the total for all
products and all territories, followed by the details of the territories; the next section
moves to the first product model, the repeats the territories, and so forth.
PivotChart and PivotTable Reports
The PivotChart and PivotTable are more powerful than the Analytic Chart and
Analytic Grid, but the PivotChart and PivotTable reports use the Office Web
Components (OWC) and this requires both an install on the client machine if they
don??™t already exist, and it requires that each user viewing the reports have a license
for the controls.
Starting either a PivotChart or PivotTable starts a wizard that asks the developer
the same three questions as any other object (name, folder, and permissions). After
filling in this information the design surface is rendered. PivotCharts have two
buttons on the toolbar that load additional tools: Commands and Options and the
Chart Wizard. Commands and Options allows for changes to the borders, toolbars,
and so forth. The Chart Wizard, on the other hand, launches a dialog box that walks
the developer through the process of creating a report. Unlike the Analytic Charts and
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 163
Analytic Grids, the PivotCharts and PivotTables can report against many different
data sources, including relational tables, cubes, XML, and more.
Pages:
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225