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)    Table that contains all measure parameters
Go
New
Search
Notify
Tools
Reply
  
Table that contains all measure parameters
 Login/Join
 
Platinum Member
posted
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
 
Posts: 100 | Registered: September 15, 2010Reply With QuoteReport This Post
Master
posted Hide Post
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!

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

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

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks, Bob! This is very helpful!


WebFOCUS 7.6.11, Linux, HTML, PDF, AHTML, EXCEL
 
Posts: 100 | Registered: September 15, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Table that contains all measure parameters

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