We have 30 measures we are updating in PMF. There are times when we need to do a "Full Refresh" and other times when we want to do Add/Replace/Delete.

Is there a way to do a global change for all measures without having to open each measure. The issue with opening each measure and changing the load option is that the prefix code can run for quite a while on each measure.

Thanks.

No way to do it now in the shipped product. But it's a good idea. We'll look into it for the future - but such a thing would not get into product in 2009.

You could of course make a form to do this. The table that contains this data is PM_MEAS_SRC_LOADPARMS, the field that contains the parameter is MEAS_LOAD_TYPE, an A1 field.

Try running this to get an idea how it fits together. You can also see the alpha values that correspond to the items you see in the dropdown by scanning this.

JOIN PM_MEAS_SRC_LOADPARMS.MEASURE_SERIES IN PM_MEAS_SRC_LOADPARMS TO PM_MEAS_SRC.MEASURE_SERIES IN PM_MEAS_SRC AS J1
END
-RUN
TABLE FILE PM_MEAS_SRC_LOADPARMS
PRINT MEAS_LOAD_TYPE
BY MEASURE_SERIES_NAME
ON TABLE HOLD
END
DEFINE FILE HOLD
DISP_MEAS_LOAD_TYPE/A70 = DECODE MEAS_LOAD_TYPE (
A    'Full Refresh'
B    'Add new, replace actual/target'
C    'Add new, increment actual/target'
D    'Add new, replace act/targ, delete old'
E    'Add new, increment act/targ, delete old'
ELSE ' ') ;
END
TABLE FILE HOLD
PRINT DISP_MEAS_LOAD_TYPE
BY MEASURE_SERIES_NAME
END

Hope this helps. And thanks for the feature idea.

You could automate this in batch without needing a form by doing a MODIFY also... FREEFORM the 'A' value in to force all to full refresh; FREEFORM the 'D' value in to force all to Add/Replace/Delete. How's that for an idea? You could do that in a couple hours. Make sure to use COMMIT and ROLLBACK in case there's a problem - you don't want to mess up the data mart.

best

Is there anyway to turn off the execution of the prefix code before the measure loader appears? That would make clicking the 30 measures much faster.