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