Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [SOLVED] automating creating manually-entered measures
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] automating creating manually-entered measures
 Login/Join
 
Platinum Member
posted
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
 
Posts: 100 | Registered: September 15, 2010Reply With QuoteReport This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Why don't you create a master ???


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Reply With QuoteReport This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
Master
posted Hide Post
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!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [SOLVED] automating creating manually-entered measures

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.