Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2010Report 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, 2003Report 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, 2010Report 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, 2003Report 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, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders