Focal Point
Measure Properties not showing all Threshold and Flex info

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

February 03, 2012, 09:52 AM
gregv
Measure Properties not showing all Threshold and Flex info
With 'Measure Properties' I don't see Treshold Value or any Flex information yet I've entered this and it shows on the reports.
This information is in the 5.2.2 User Doc example.
My user has requested this information to available to a User role.
We are using 5.2.3 HF4.

Has this object changed? Do I need to change a setting to see the Treshold value and Flex information?

Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
February 03, 2012, 01:48 PM
Bob Jude Ferrante
When PMF was changed to allow more than the default tolerance profile of H-M-L, all assumptions were off so value for flex information had to drop off the properties report, since there were now a variable number of levels to be dealt with.

We will put that info back eventually.

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 03, 2012, 01:59 PM
gregv
Ok. Thanks, Bob.

Can the Threshold value and Flex information be retrieved?

Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
February 03, 2012, 02:59 PM
Bob Jude Ferrante
Now you're making me design this change :-)

These values used to be stored in the measure series table (renamed to pm_meas_src) but now they're in a separate table (PM_MEAS_SRC_BRKPNT_VALS ) to allow the number of levels to be soft.

You could issue a request by JOINing PM_MEAS_SRC to PM_MEAS_SRC_BRKPNT_VALS_VW. Since you're running 5.2.3HF4 this is a listing report that should work:

-INCLUDE A_DEFAULTS
JOIN MEASURE_SERIES IN PM_MEAS_SRC_BRKPNT_VALS_VW TO MEASURE_SERIES IN PM_MEAS_SRC AS JOIN1
-RUN
DEFINE FILE PM_MEAS_SRC_BRKPNT_VALS_VW
FTYPE/A15 = IF (TLRNC_LVL_LOWER EQ 1) THEN 'Threshold' ELSE 'Flex' ;
END
TABLE FILE PM_MEAS_SRC_BRKPNT_VALS_VW
PRINT
FTYPE
BRKPNT_VALUE
BY MEASURE_SERIES_NAME
WHERE MEASURE_FIELD_NAME EQ 'TARGET' ;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET STYLE *
-INCLUDE A_STYLE01
END

If you wanted to show the info for only one measure you could issue a WHERE on MEASURE_SERIES.

Same extraction principle would apply for the properties report which is already doing such a filter. The 5.2.3HF4 properties report took out the old code that got the tolerances. A revised one would need to put them back using these principles.

We'll get to it sometime in 5.3! Meantime you could customize if you like.

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 04, 2012, 11:03 AM
gregv
This is great, Bob.

Thanks for the help.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8