Focal Point
[CLOSED] Extracting fields from reports

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

March 07, 2019, 04:56 AM
joao.moreira
[CLOSED] Extracting fields from reports
Dear,

I'm new with WF and I've been learning the Focus language for the past month.

I need to extract all report fields - not the original fields from the masterfiles, but the fields that are displayed by the reports - and I wonder if WF already provides this type of functionality.

The goal is to enable users to explore the available fields from the existing reports, being able to search by either the field display name and original name. For example if a report has a "BY XPTO AS 'Product name'", the user should be able to find this report either by searching for "XPTO" or "Product name". The same for any other command that prints fields in a report, such as COMPUTE and ACROSS. Furthermore, the UI should present the list of all fields grouped by their display name, where the user can drill down to the related reports.

A solution for this requirement could be a program that parses the fex files, but it would be required to understand the entire Focus grammar. Is Focus grammar available somewhere?

Our WF version is 8.1.05.

Thank you!

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus 8105m
Windows/Linux
March 07, 2019, 05:08 AM
Efrem
There might be other ways to do this but if WebFOCUS Web Services is licensed, it is possible to get the PRINT/SUM, SORT, JOINS, MASTER,WHEREs, and Output format for a particular FEX.
March 13, 2019, 04:45 AM
joao.moreira
Hi, thanks for the response.
I tried to find the service/endpoint for the functionality that you mentioned but I couldn't find it. I only find in the documentation the method to retrieve the parameters of a report:
https://infocenter.information...source%2Ftopic21.htm

Can you provide the pointer to the documentation of the service that you mentioned, please?

I wonder whether there are best practices or methdologies for report management? We have numerous reports and we need to control what type of information is provided by them.

I also wonder if there are any initiatives in WebFocus related to semantic web technologies/linked data, which is a common approach to deal with this type of interoperability issue.

Thank you!


WebFocus 8105m
Windows/Linux
March 14, 2019, 09:47 AM
FP Mod Chuck
Joao I got this info from the product manager. The getDetails action is documented on page 93 of this manual. https://webfocusinfocenter.informationbuilders.com/wfdesigner/pdfs5/embedded_bi_8205.pdf This is the webservice URL associated with that doc. http://host[:port]/ibi_apps/rs?IBIRS_path=path&IBIRS_action=getDetails&IBIRS_service=describe The only rule is that the procedure needs to be able to be parsed by the parser that InfoAssist uses. The parser handles more than the InfoAssit GUI though. I hope this helps. If you need more assistance please open a case with techsupport.

This message has been edited. Last edited by: FP Mod Chuck,


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats