Hello,

We would like to get a better idea of how the master files in our current EDASERVE environment are being used and gather data to eventually assist in building a data dictionary/repository. Is there a way to systematically (preferably through the WF interface) gather statistics regarding master files? Ideally, we'd like to know what reports are built upon a given master file, what tables a given master file references, etc.

Thanks,


sleepy

Look into Resource Analyzer

For individual masters, you can run the Impact Analysis tool available in the 7.6 version which you have.

You can also do things the hard way as I have done by putting lists of masters and focexecs into flat files using operating system commands, defining them with generic masters (I call mine LINE80), parse to get the master name out, then loop through each line in focexecs looking for TABLE FILE or SQL syntax, extracting the master name, then matching this list up with the master list to find out which are used. Be creative.

I think this was discussed in another topic awhile back.

quote:

Originally posted by Francis Mariani:
Look into Resource Analyzer

Thank you, Francis. I will research the Resource Analyzer.


sleepy

quote:

Originally posted by GinnyJakes:
For individual masters, you can run the Impact Analysis tool available in the 7.6 version which you have.

Thanks...I will look into the Impact Analysis tool.

quote:

Originally posted by GinnyJakes:
You can also do things the hard way as I have done by putting lists of masters and focexecs into flat files using operating system commands, defining them with generic masters (I call mine LINE80), parse to get the master name out, then loop through each line in focexecs looking for TABLE FILE or SQL syntax, extracting the master name, then matching this list up with the master list to find out which are used. Be creative.

That certainly is creative! I've just learned through speaking with our WebFocus/DBA administrator about this topic that he has been working on an in-house solution for querying which users are in which roles/groups that might, with a little tweaking, satisfy my needs . I'll post back when I've seen it.

quote:

Originally posted by GinnyJakes:
I think this was discussed in another topic awhile back.

Whoops...my apologies. I tried searching the forums before creating this thread, but my search terms must not have been adequate. I will try again.


sleepy

Here are some Forum links:

https://forums.informationbuilders.com/eve/forums/a/tpc/...041060082#6041060082

https://forums.informationbuilders.com/eve/forums/a/tpc/...991040662#7991040662

https://forums.informationbuilders.com/eve/forums/a/tpc/...321048482#8321048482

https://forums.informationbuilders.com/eve/forums/a/tpc/...521042692#4521042692

https://forums.informationbuilders.com/eve/forums/a/tpc/...131009592#1131009592

These might give you some ideas and/or other things to search for or read up on.