Focal Point
Table that contains all measure parameters

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

January 12, 2011, 06:21 PM
JBK
Table that contains all measure parameters
I need to create a webfocus report the lists all parameters for each measure. We need this for documentation and tracking purposes. I was getting some of the parameters from various tables in pmfora and joining them.

Today I found that the PM_MEAS_SRC_PROPERTIES_VW table that has most of the measure parameters that are in the Measure screens in the Manage tab. Can you tell me which other tables would have the other parameters, so that I can join them to this one? It would save a lot of time to have this info.

Thank you.

This message has been edited. Last edited by: JBK,


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
January 13, 2011, 12:38 PM
Bob Jude Ferrante
Did you check to see if what you need is already on the Analytics tab, Administration reports? Try Measure Load and Measures...

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!

January 13, 2011, 01:20 PM
JBK
I did look at these, Bob, and it's not what we need.

Currently we have an excel spreadsheet where all the parameter data for each measure is manually entered, one row per measure. Being a webfocus developer, I need to automate this. It's a simple report, I just need to find out which tables to use to get all the data.

Thank you.


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
January 13, 2011, 01:26 PM
Bob Jude Ferrante
Why not examine the reports I'm pointing you at to see how to do it? They get the same data - they might not be in the format you want but the tables and fields are all there.

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!

January 13, 2011, 01:28 PM
Bob Jude Ferrante
Anticipating your next question...

You can find the focexecs used under Manage > Content, in case you're not searching FocalPoint to see how to do that. Find the named view and click it in the tree. The WebFOCUS procedure is found in /apps/mainstreet/

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!

January 13, 2011, 01:58 PM
JBK
Thanks, Bob! This is very helpful!


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL