Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2019Report 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: 229 | Location: New York | Registered: July 27, 2004Report 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, 2019Report 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: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders