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,

Did you check to see if what you need is already on the Analytics tab, Administration reports? Try Measure Load and Measures...

thanks

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.

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

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

Thanks, Bob! This is very helpful!