Let's Get Social!
Focal Point    Focal Point Forums    WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Creating Custom Resource Analyzer Reports
 Go New Search Notify Tools Reply
 [SOLVED] Creating Custom Resource Analyzer Reports
Silver Member
 posted July 15, 2016 03:28 PM
Good afternoon everyone,

I just have a quick question, and hopefully someone will have an easy answer for me.

I need to create custom reports using the Resource Analyzer tool, and in order to do that, I first need to be able to locate the appropriate master files. I've spent the last couple hours searching through the WebFOCUS documentation/forum/knowledge-base for a solution, but I cannot seem to locate where they are. From what I've seen, I believe one of the master files is called rmldb.mas. Does anyone know where these master files are located?

So far, I have used a WHENCE statement on the RMLDB MASTER to try and locate the master file, but it returned this error: (FOC1892) FILE NOT FOUND : RMLDB MASTER. Moreover, I searched through the Resource Analyzer manual and couldn't find an answer.

I also have found several similar threads, but strangely I couldn't find a solution that worked for me (maybe the threads are outdated?). Here are links to some of the threads: http://forums.informationbuild...1057331/m/6987076826
http://forums.informationbuild...1057331/m/4917034295
http://forums.informationbuild...1057331/m/9741036472

I am fairly new to WebFOCUS and this may be a silly question, but I would really appreciate any help.

Matt

This message has been edited. Last edited by: mlhapner,

WebFOCUS 8.201m
Windows, All Outputs

 Posts: 28 | Location: Indiana | Registered: June 08, 2016 IP
Silver Member
 posted July 19, 2016 11:20 AM Hide Post
Any ideas??

WebFOCUS 8.201m
Windows, All Outputs

 Posts: 28 | Location: Indiana | Registered: June 08, 2016 IP
Platinum Member
 posted July 20, 2016 05:24 AM Hide Post
Hi

If you run the pre-defined reports and click on view source you will the logic, Appending the data stored in the database repository and the data gathered during the day in the data file


TABLE FILE _EDACONF/CATALOG/RM/RMLDB
SUM
SMELAPTIME SMCPUTIME SMIOS SMROWS
CNT.SMCMDNUM AS 'CMDCOUNT'
CNT.DST.SARPCNAME AS 'RPCCOUNT'
COMPUTE FIRSTDATE/MDYY = MIN.STRTDATE;
COMPUTE LASTDATE/MDYY = MAX.STRTDATE;
BY SMUSERID

WHERE SMSRVNAME EQ 'LOCALHOST:8121' AND SMSRVNAME EQ SMSERVER
AND SESSKEY EQ SMKEY
AND SMDATE GE '20150304' AND SMDATE LE '20160720'
ON TABLE HOLD AS SAUSU FORMAT ALPHA
-IF WINNT    EQ 'PDS' THEN GOTO NOPDS ;
MORE
FILE _EDACONF/CATALOG/RM/RMLDATA
WHERE SMSRVNAME EQ 'LOCALHOST:8121' AND SMSRVNAME EQ SMSERVER
AND SESSKEY EQ SMKEY
AND SMDATE GE '20150304' AND SMDATE LE '20160720'
-NOPDS
END
-RUN



The location of the master files:

\ibi\srv81\home\catalog\rm

Yours

Eran

Yours,
Eran
SRL Products

http://www.srl.co.il

 Posts: 97 | Location: Tel Aviv, Israel | Registered: November 20, 2005 IP
Silver Member
 posted July 20, 2016 10:26 AM Hide Post
Eran,

I can't seem to find where I can view the source for the pre-defined reports. All I see is "Run" "Submit" and "View Submitted Reports." Could you add a screenshot for where you click to view source or maybe give a description to where it is at?

Thanks,

Matt

WebFOCUS 8.201m
Windows, All Outputs

 Posts: 28 | Location: Indiana | Registered: June 08, 2016 IP
Platinum Member
 posted July 20, 2016 10:36 AM Hide Post
quote:
Originally posted by mlhapner:
I can't seem to find where I can view the source
Matt

This is a feature of the browser not webFOCUS. Right click in the frame - view pae source -

webFOCUS 8203
WindowsServer 2012 R2,
Excel, PDF, HTML, ActiveReports

 Posts: 124 | Location: Minnesota | Registered: August 26, 2013 IP
Master
 posted July 20, 2016 10:37 AM Hide Post
quote:
Originally posted by mlhapner:
I can't seem to find where I can view the source for the pre-defined reports.
Matt

Does this open up in a browser? Maybe Eran meant "view source" in the browser. Try right-clicking in the browser's window area.

App Studio
WebFOCUS 8.1.05M
Windows, All Outputs

 Posts: 594 | Location: Michigan | Registered: September 04, 2015 IP
Silver Member
 posted July 20, 2016 10:42 AM Hide Post
Thanks guys!

Yep, right clicking the window and clicking "view frame source" did the job.

WebFOCUS 8.201m
Windows, All Outputs

 Posts: 28 | Location: Indiana | Registered: June 08, 2016 IP

Focal Point    Focal Point Forums    WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Creating Custom Resource Analyzer Reports