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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Report Caster Data Files

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Report Caster Data Files
 Login/Join
 
Member
posted
I want to create a .fex from data within Report Caster jobs. Where are the files located on the server and the names?
For example I would like to create a datamart that would query a specific Schedule ID to get the Job Description and the details behind that scheduled job (specific Task Scheduled, time scheduled,...).

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


7.6.8
UNIX
FOCUS,HTML,PDF,EXCEL.
 
Posts: 18 | Registered: September 29, 2010Report This Post
Expert
posted Hide Post
Todd, I think you meant RC tables. First, what kind of data base is used for your RC repository? Once you know that, you can use the WF console or Developer Studio to create the master file descriptions from the appropriate adapter. Then you can write reports against the tables to your heart's content.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
I haven't got any idea as to why you would want to do such a thing, but if you want to do so, go ahead. You can find the master files in the server's catalog directory. They all start with BOT. That is, they will be there up to release 7.7. As of 77 and higher you won't find the masters any more, so your idea of datamarting the RC tables will end with that release anyway.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Gold member
posted Hide Post
I did something similar which may point you in the direction you want to go

http://forums.informationbuild...=308102704#308102704


81.05 All formats
 
Posts: 56 | Location: Manchester | Registered: November 21, 2006Report This Post
Master
posted Hide Post
GamP or anyone. Why would those masters for the RC data files be going away?


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Expert
posted Hide Post
You may not "find the masters" but what will stop you from generating metadata for the tables?


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
I'm looking for the BOTSCHED & BOTTASK files, but can not find them. I'm looking in the ReportCaster76 locatioin, am I looking in the wrong place? Any help would be appreciated. I'm trying to do the same thing PBax is...great stuff!


7.6.8
UNIX
FOCUS,HTML,PDF,EXCEL.
 
Posts: 18 | Registered: September 29, 2010Report This Post
Member
posted Hide Post
OK...I think I found them. I'm good to go. I can now make some reporting on this data.


7.6.8
UNIX
FOCUS,HTML,PDF,EXCEL.
 
Posts: 18 | Registered: September 29, 2010Report This Post
Expert
posted Hide Post
quote:
As of 77 and higher you won't find the masters any more
This is because a new database is being used as default. However, configuring a JDBC adapter will still allow you to get to the repository and create the synonyms and therefore allow you to continue your quest.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
Tony, I assume that is the same DB as for MRE...


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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] Report Caster Data Files

Copyright © 1996-2020 Information Builders