Clearout3
The process can be further restricted. Clearout3 fixes dimensions 0 and 1 (YEARS and ACTVSBUD) and uses all elements of the other four dimensions as shown in this table:
| Id | DimIdx | ColumnName | TargetElement |
|---|---|---|---|
| 12 | 0 | NULL | 2003 |
| 12 | 1 | NULL | Actual |
| 12 | 2 | REGIONS | NULL |
| 12 | 3 | PRODUCTS | NULL |
| 12 | 4 | MONTHS | NULL |
| 12 | 5 | MEASURES | NULL |
Clearout3 clears a four-dimensional sub cube.