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 firstname.lastname@example.org and provide your corporate email address, company, and name.
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,
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.
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, 2005