Is there a way to automate creating user-entered measures? We have a person who has a spreadsheet of measures to manually enter into PMF.

Obviously this can become very time consuming with a large number of measures.

Is there a way to upload a .csv or other file into PMF so that this can be automated?

Thank you.

This message has been edited. Last edited by: JBK,

Sorry to say there's no way to import Measure headers from a spreadsheet or CSV. We'll consider this as a future feature, but that won't do your co-worker much good today.

thanks

Why don't you create a master ???

I don't know. Why don't we? Hey!

:-)

BUT...

If you're a coder....

And you know how to use -READ and check for End Of File and loop until then...

And the CSV file is clean (take those nasty double quotes OUT OF THERE, use standardized floating point notation, thank you)...

(and you create a master file, yea, Carlos)...

You can write a program to batch this process.

Note that this program would be version-specific; we can't guarantee these vars won't change over time. But if you're looking for a solution for now... you do have to write it... but you can.

If you turn on AJAX tracing, then manually add a measure, PMF itself will show you the way.
Not all these vars are required. You can default many of them. The RHS of these values would come from your CVS file. Got the picture?
I've added comments to indicate which are which...
Some of these varnames are non-obvious but most match the display values on the English language New Measure panel. See?
We'll also look into putting in a feature but that's long-term.
Good hunting.
-bjf

-*heading
SET DMPRECISION = 9
-RUN
-SET &ENCODE_CNT=9;
-SET &RUN_FILTERS='N';
-SET &Action_Field_Edit='i';
-SET &MEASURE_SERIES='';
-*required values
-SET &MEASURE_SERIES_NAME='AAAA';
-SET &ENCODE_FLD01='MEASURE_SERIES_NAME';
-SET &RECORD_TYPE='L';
-SET &RECORD_TYPE_OLD='';
-SET &MEAS_DIMS='TL';
-SET &ENCODE_FLD02='MEAS_DIMS';
-SET &MEASURE_AGGREGATE_TYPE='A';
-SET &THRESHOLD_FLEX_DIRECTION='A';
-SET &THR_FLE_TYP='P';
-SET &MEASURE_FORMAT='D12';
-SET &ENCODE_FLD03='MEASURE_FORMAT';
-SET &UNIT_ID=24;
-SET &MEAS_REPORT=7;
-*Optional values - well, anyway, these can be defaulted
-SET &ROW_SECURITY='N';
-SET &MEASURES_AUDIT_FLAG='N';
-SET &PPMF_FLAG='N';
-SET &TIME_SUMMARY_IND='S';
-SET &CHANGE_ID='pmfadmin';
-SET &OWNER_ID='pmfadmin';
-SET &MEASURE_SERIES_DESC='My Nice Measure';
-SET &ENCODE_FLD04='MEASURE_SERIES_DESC';
-SET &MEASURE_SOURCE_FORMULA='';
-SET &ENCODE_FLD05='MEASURE_SOURCE_FORMULA';
-SET &WIZARD_MODE='N';
-SET &THRESHOLD=10;
-SET &FLEX=5;
-SET &TARCNT=0;
-SET &SCORECARD_ID=0;
-SET &OBJECTIVE_ID=0;
-SET &SINGLE_TARGET='';
-SET &ACTUAL_NUMERATOR='';
-SET &ENCODE_FLD06='ACTUAL_NUMERATOR';
-SET &ACTUAL_DENOMINATOR='';
-SET &ENCODE_FLD07='ACTUAL_DENOMINATOR';
-SET &TARGET_NUMERATOR='';
-SET &ENCODE_FLD08='TARGET_NUMERATOR';
-SET &TARGET_DENOMINATOR='';
-SET &ENCODE_FLD09='TARGET_DENOMINATOR';
-SET &TOLERANCE_CNT=1;
-SET &PCT_RCHD_PRCS_TYP='T';
-SET &PCT_RCHD_BASIS='';
-SET &MEAS_AGGR_OPT='';
-SET &FIXED_TARGET_FLAG='N';

-INCLUDE PMF_PM_MEAS_SRC_FORM_UPDATE