Page 204 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Data Warehousing and Data Mining

notes

is transformed into the L.A. table

The DICE command, in contrast to SLICE, requires the user to impose restrictions on all
dimensions in a given data cube. An example SLICE command, which provides data about sales
only in L.A., and DICE command, which provides data about sales of Canon printers in May
2002 in L.A.

PIVOT Command

PIVOT is used to rotate a given data cube to select a different view. Given that the user currently
analyses the sales for particular products in the first quarter of 2002, he/she can shift the focus to
see sales in the same quarter, but for different continents instead of for products, i.e., the view.
figure 10.11: example of DriLL DoWn command

198 LoveLy professionaL university