Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2016Report This Post
Silver Member
posted Hide Post
Any ideas??


WebFOCUS 8.201m
Windows, All Outputs
 
Posts: 28 | Location: Indiana | Registered: June 08, 2016Report 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, 2005Report 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, 2016Report 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 8207.15
WindowsServer 2019
 
Posts: 120 | Location: Minnesota | Registered: August 26, 2013Report 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, 2015Report 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, 2016Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders