Database Reference
In-Depth Information
s total sales for irons, the query dices
the sliced data cube, reducing it to the shaded portion shown in Figure 9-17.
If the sales manager
'
s next query displays this week
'
Part
Customer
299
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
ssales,and
the second query reduced the slice by dicing only the cells in the data cube that are for irons.
The sales manager
'
s first query sliced the data cube to focus on the current week
'
￿
Drill down. When you view specific aggregate data, you drill down the data to view and analyze
lower levels of aggregation; that is, you go to a more detailed view of the data. For example, sup-
pose 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.
Search WWH ::




Custom Search