Databases Reference
In-Depth Information
If the sales manager's next query displays this week's total sales for irons, the query dices the
sliced data cube, reducing it to the shaded portion shown in Figure 9-17.
Part
Customer
297
Selected segment
contains data for
the current week's
iron sales
Week1 ••• ••• ••• Week
Current
Time
FIGURE 9-17
Dicing the sliced data cube based on the Part dimension
The results for the sales manager's queries for this diced portion of the data cube appear in
Figure 9-18.
TotalDollars
TotalUnits
$241.45
11
FIGURE 9-18
Query results for total sales of irons
The sales manager's first query sliced the data cube to focus on the current week's sales, and
the second query reduced the slice by dicing only the cells in the data cube that are for irons.
Drill down.
When you view specific aggregate data, you
drill down
the data to view and ana-
lyze lower levels of aggregation; that is, you go to a more detailed view of the data. For example,
suppose again that the sales manager queries the data warehouse to view this week's total sales,
as shown in Figure 9-15. To analyze details of these sales, the sales manager might drill down to
view total sales by class, as shown in Figure 9-19.
●
Class
TotalDollars
TotalUnits
AP
$4,499.79
13
HW
$241.45
11
SG
$4,169.90
4
FIGURE 9-19
Query results for total sales by class
Finally, the sales manager might drill down to view total sales by part within class, as shown
in Figure 9-20.
