Database Reference
In-Depth Information
The
PivotTable
Fields List
pane—select the
report elements to
be displayed here
The
Pivot Table
report are—the
Pivot Ta ble will be
displayed in this
are, which can be
extended as
necessary to
accommodate the
PivotTable
(i)
The PivotTable in the New Worksheet
The
PivotTable
Field List
pane—
the elements have
been selected and
are now displayed
here
The
PivotTable
report
The PivotTable
worksheet has been
named the
HSD-DW-BI-Pivot-Table
Figure 12-21
Continued
(j)
The ProductNumber by City OLAP Report
Unfortunately, all of this flexibility comes at a cost. If the database is large, doing the nec-
essary calculating, grouping, and sorting for such dynamic displays will require substantial
computing power. Although standard, commercial DBMS products do have the features and
functions required to create OLAP reports, they are not designed for such work. They are
designed to provide rapid response to transaction processing applications, such as those for
order entry or manufacturing planning.
Search WWH ::
Custom Search