Examples for clearing a cube region

The examples in this section describe how to define jobs to clear a data area in a cube.

All examples use a data cube named TOTSALES with six dimensions: YEARS, ACTVSBUD, REGIONS, PRODUCTS, MONTHS, and MEASURES.

TOTSALES YEARS
ACTVSBUD
REGIONS
PRODUCTS
MONTHS
MEASURES

These tables list the elements of the dimensions:

YEARS
2002
2003
2004
2005
2006
ACTVSBUD
Actual
Budget
REGION
USA
Canada
Mexico
PRODUCTS
ProView VGA 12
ProView VGA 14
ProView VGA 15
ProView SVGA 14
ProView SVGA 15
MONTHS
January
February
March
April
May
MEASURES
Sales
Variable costs
Units