Focal Point
[SOLVED] automating creating manually-entered measures

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/5447061995

February 22, 2011, 02:04 PM
JBK
[SOLVED] automating creating manually-entered measures
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,


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
February 22, 2011, 02:20 PM
Bob Jude Ferrante
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


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

February 23, 2011, 01:25 PM
Carlos Da Costa
Why don't you create a master ???


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
February 23, 2011, 02:08 PM
Bob Jude Ferrante
I don't know. Why don't we? Hey!

:-)


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

February 23, 2011, 03:31 PM
Bob Jude Ferrante
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


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!