Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Creating Custom Resource Analyzer Reports
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Creating Custom Resource Analyzer Reports
 Login/Join
 
Silver Member
posted
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.

Thanks in advance,

Matt

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


WebFOCUS 8.201m
Windows, All Outputs
 
Posts: 28 | Location: Indiana | Registered: June 08, 2016Reply With QuoteReport This Post
Silver Member
posted Hide Post
Any ideas??


WebFOCUS 8.201m
Windows, All Outputs
 
Posts: 28 | Location: Indiana | Registered: June 08, 2016Reply With QuoteReport This Post
Platinum Member
posted 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, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
Eran,

Thanks for your reply.

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, 2016Reply With QuoteReport This Post
Platinum Member
posted 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, 2013Reply With QuoteReport This Post
Master
posted 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, 2015Reply With QuoteReport This Post
Silver Member
posted 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, 2016Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.