Clearout2

The difference between Clearout1 and Clearout2 is that for dimension 0 (YEARS), the column name is NULL and an element is named as target element as shown in this table:

Id DimIdx ColumnName TargetElement
11 0 NULL 2003
11 1 ACTVSBUD NULL
11 2 REGIONS NULL
11 3 PRODUCTS NULL
11 4 MONTHS NULL
11 5 MEASURES NULL

This tells the process to clear out only the cells which have element 2003 of dimension 0 (YEARS) and any element of the other five dimensions. Clearout2 clears out a five-dimensional sub cube.