The default
is 1000 records, although this can certainly be changed.
After changing any properties as desired and choosing the location of the
PivotTable report from the Import Data dialog box, the PivotTable is added to
the spreadsheet and the Field List window is placed on the right-hand side of the
spreadsheet. Figure 9-5 shows the default layout for the Field List as well as the
empty PivotTable on the spreadsheet.
Figure 9-4 The Connection Properties dialog box can control data refreshes, cube
formatting options, and the number of records to retrieve when drilling
through, among other options.
C h a p t e r 9 : A n a l y s i s w i t h E x c e l 2 0 0 7 301
The Field List is broken into two sections: a Fields section and an Areas section.
By default the Fields section is on top and the Areas section is below the Fields
section and contains four boxes for the filter, columns, rows, and values (the
measures). The Fields section contains the measures first, broken down in measure
groups. Next come the KPIs, followed by the dimensions and their attributes and
hierarchies.
The layout of the Field List can be changed. At the top of the Field List is a button
that can alter the layout to show the Areas section beside the Fields section, the
Fields section only, or the Areas selection only in a couple of different layouts. On
the Options tab of the ribbon bar, which appears under a larger PivotTable Tools tab,
there is a button labeled Field List that can toggle the entire panel on and off.
Pages:
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390