Clearout1

The _FactLoad table has the ID for Clearout1 as 10. There are six lines in the _FactLoadParameters table linked to ID 10. There is one line for each of the dimensions in the TOTSALES cube. These dimensions are numbered in accordance with the server's numbering of a cube's dimensions. They are zero-based.

The column name is actually a reference to the name of a column of a fact load table. The name is not needed here because clear-outs do not have source tables. However, the dimension it relates to can be put there for clarity.

This table describes the first row:

Id	DimIdx	ColumnName	TargetElement
10	0	YEARS	NULL

This tells the process to use the whole of dimension 0, YEARS, in the clearing out process.

This table shows all of them together for ID 10:

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

Together they inform the process to use all the elements of all six dimensions. Clearout1 clears out the whole cube.