Focal Point
[SOLVED] Words Analysis

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

May 19, 2017, 07:16 PM
sh98110
[SOLVED] Words Analysis
Anyone have any experience to report with the Words_Analysis Adapter? Only one case out there in the knowledge base, and no comments here in FOCAL Point? Thanks in advance.

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


WebFOCUS 8
Windows, All Outputs
May 20, 2017, 03:38 PM
David Briars
I took a look at the Words Analysis Adapter and Tag Cloud visualizations a few years ago, when we were 'kicking the tires' on 80.

I downloaded the prepared text of the Commencement address delivered by Steve Jobs, CEO of Apple Computer and of Pixar Animation Studios, on June 12, 2005 into a text file:

I then enabled the 'Words Analysis' adapter, and created the following code:
APP PREPENDPATH WORK
-*
JOIN DOCLINE IN SPEECH TO DOCUMENT IN ibisamp/wan_document AS J1
-*
GRAPH FILE SPEECH
SUM WORD_COUNT 
BY  WORD
-* Drop 'noisy' words.  
IF WORD NE 'college' OR 'dropped' OR 'months' OR 'ten' OR '30'
-* Drop words used only once or twice.
IF TOTAL WORD_COUNT GT 2
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH TAGCLOUD
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_JS
 tagcloudProperties: {font: 'bold 12pt Verdana'},
 yaxis: {colorScale: {colors: ['#fd8d3c','#f03b20','#bd0026','black']}}
*END
ENDSTYLE
END  

Rendered in the browser:


Note: In the GRAPH FILE command above, SPEECH is the master for the text file. WAN_DOCUMENT is the master provided by WebFOCUS, to support 'word counting'.

Other than this due diligence test during our 80 install period, I haven't encountered a use case to require me to pursue Words Analysis/Tag Clouds further. It would be cool to take this up again if I do get a requirement.

This message has been edited. Last edited by: David Briars,




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
May 22, 2017, 08:36 AM
BabakNYC
Combining WAND with Sentiment Analysis is the ideal way of using the adapter. You can count the frequency of words, and score them depending on their Positive, Negative or Neutral definition. You can also filter out noise (things like this, that, and, et cetera) out of the text. It works great.


WebFOCUS 8206, Unix, Windows
May 23, 2017, 12:47 PM
sh98110
Babak, nice to hear from you. The WAND adapter looks like it comes with (via IBI) a WAND server, WAND Taxonomy Editor, and that you also need Adobe Air (downloadable). Did I miss anything?

Have any customers using this and/or Word Services?

Thanks.


WebFOCUS 8
Windows, All Outputs
May 23, 2017, 12:49 PM
sh98110
David, thanks for the post.


WebFOCUS 8
Windows, All Outputs
May 23, 2017, 01:19 PM
BabakNYC
It's been a while since I set it up. I can't remember all the components.


WebFOCUS 8206, Unix, Windows