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  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Extracting fields from reports
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Extracting fields from reports
 Login/Join
 
Member
posted
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
 
Posts: 2 | Registered: February 22, 2019Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.
 
Posts: 217 | Location: New York | Registered: July 27, 2004Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 2 | Registered: February 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1576 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Extracting fields from reports

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