Focal Point
[SOLVED] WebFOCUS 8 - Impact Analysis on Content Node.

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

February 12, 2014, 10:12 AM
David Briars
[SOLVED] WebFOCUS 8 - Impact Analysis on Content Node.
In WebFOCUS 7.7.02 I could use the Windows 7 Explorer Search function, to search Managed Reporting domains for focexecs for where I use 'CAR' or 'GGSALES'.

In WebFOCUS 8.0.06, what are our options, to search focexecs in the Content Node? ('Content' node replaces 'Managed Reporting' node in WF 8.)

Without the ability to search focexecs in Content, code maintenance efforts could be severely hampered.

As far as I can tell, the WebFOCUS 8 'Impact Analysis' function will only search focexecs in the application folders.

This message has been edited. Last edited by: David Briars,
February 12, 2014, 11:51 AM
MattC
If you right click on Content and change your view to "Full View". Expand out the WFC Folder, then you can right click on the Content Folder and select Search.

Not exactly what your looking for, but it's a start.




WebFOCUS 8.1.05
February 12, 2014, 02:37 PM
David Briars
Thanks for your offer to assist, Matt.

The instructions and screen print you show seems to come from the 'WebFOCUS BI Portal' web page.

Developers at our site use WebFOCUS Developer Studio as our IDE. Therefore, I am looking at a tool/method/process within WFDS.

I looked at the 'Search' function, of the BI portal you showed us. It appears to only search through the names of focexecs that contain a given string.

Before we perform maintenance, we often need to search through the contents of focexecs (Impact Analysis).

Once again, thanks for showing us how to look for fex names.

Any other comments/ideas...I am all ears.
February 18, 2014, 02:04 PM
<Kathryn Henning>
Hi David,

I see that you've got a case opened for this and are working with us on the issue. Please keep us updated on your final outcome.

Thanks and regards,

Kathryn
February 18, 2014, 03:09 PM
Francis Mariani
I bet you the workaround will be to use some utility that extracts the programs from the database table and creates a zip file. Then you unzip and use a real text editor (e.g. EditPlus) to search the extracted files.

Since WF v4.3.6 I've used EditPlus to perform my impact analysis - just point to the MRE or app folder and search in files. I'm going to miss this in WF v8.

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 18, 2014, 05:16 PM
David Briars
@Kathryn - Yes, I will keep everyone updated on my case.

@Francis - I am have difficulty getting IB to understand the importance of 'find string in *.fex files' and 'compare two .fex files'. So I appreciate the support on this matter.
February 18, 2014, 05:43 PM
Francis Mariani
Perhaps 'find string in *.fex files' and 'compare two .fex files' is not understood (which I'm always doing) is because looking at code seems to be frowned upon in this brave new world we live in.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 18, 2014, 05:54 PM
David Briars
Aldous Huxley, where are you when we need you? Smiler

.....

I did write in a question, into the 'Ask Gerry' session at Summit 2013 regarding coding, and the answer was that IB would continue to support the coder/developer and the IDE.

This message has been edited. Last edited by: David Briars,
February 18, 2014, 06:47 PM
j.gross
While we're at it, it would also save much grief if the file date were preserved by Dev Studio when copying a file between environments -- as when promoting a fex or synonym from Dev to QA. Seems to me if FTP can do it, it should not be beyond IBI to make Dev Studio do the same.
February 19, 2014, 09:47 AM
George Patton
@Jack:
Yes indeed .....

This message has been edited. Last edited by: George Patton,


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
February 19, 2014, 11:31 AM
Francis Mariani
File dates are not preserved when using MRE migration tools, even though there are check-boxes for Preserve Creation and Modifier info.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 21, 2014, 08:03 AM
CLH
Starting in 8.0.0.7 you can set a flag in the admin console sh that when you create export scenarios it will also export the code in text format. You can then search it not the best solution but at least a way to do it.

Crystal


Webfocus 8.0.7 on Windows
June 10, 2014, 03:29 PM
David Briars
Thread Update:

Our open case on this matter, had transitioned to a New Feature Request.

Looks like the NFR worked!

We recently upgraded to WF 8.0.07, from 8.0.06.

With 07, after selecting the Repository Content node, or folders within Content, the context menu reveals 'Impact Analysis'.

'Impact Analysis' can then be used to search for master/field names throughout content.




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
June 10, 2014, 03:44 PM
Francis Mariani
Interestingly, I just today tried to use Impact Analysis in DevStudio v7.7.05 (it exists - you right-click a domain and select Impact Analysis). After selecting a Master and being apparently forced to enter a field name, it crashed Dev Studio.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 10, 2014, 03:59 PM
Tom Flynn
This is what I get:




Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
June 10, 2014, 05:28 PM
David Briars
Tom-

After clicking the 'Analyze' button, the 'Impact Analysis Result' form fills with the results of the 'finds' AOK for me.

Not sure what kind of error message you are getting, but do you have access to the two folders you chose to search?

-Dave




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
June 11, 2014, 08:23 AM
Tom Flynn
Hi David,
I'm an Admin, have access to every table in Banner and ODS..
Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe