I have one question to add. The data involved will be far to large is seems so I was thinking off only generating enries for the 1st day of each month. Does anyone have an idea on how to change this to only add the 1st date of everymonth?
// ---- B: Create all combinations of product and date
Load distinct ProductID Resident TempProductBalances;
Load Date(recno()+$(vMinDate)) as DateKey Autogenerate vMaxDate - vMinDate;