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.
Check the Report Caster Administration manual, Appendix B. It refers to sample reports that are stored in the ibisamp directory. Also you can create synonyms for all of your BOT tables and write your own programs. Appendix B also documents the tables.
You will have to fool around with the time stamps. There are many posts regarding this topic in the Forum. Also Susannah has an article on the IBI web site.
Hi ginny, can you give me a work flow about how i can proceed with my task,i.e;how to create a report caster report that automatically sent to me when a user schedules a job as i am pretty new to report caster.
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
There is no "report caster report" to do what you want. What Ginny and Francis are saying is that you have to write your own report off the BOT tables and then schedule that report in RC like you would any other report and add a trigger for it to send you a report when a new record has been added (probably determined from a datetime timestamp in the table.) All documented in the manual. Sounds like you need to familiarize yourself a little with RC before jumping in. Maybe some training would be in order?
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
Hi, i am trying to find the location of this master file (table)--BOTSCHED in my system.i am using this for doing it :WHENCE BOTSCHED MASTER,but i am getting a location under 'F' drive but there is no'F' drive at all in my system. so where exactly i can find the above master....
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
Also you can create synonyms for all of your BOT tables
You have to create them with the web console or have an admin create them for you. A synonym is a master file. WF doesn't come with as each site can use a different data base type.
Hey francis, i got into the folder i,e; where the WF installed but i cannot see the master for the botsched,all i can only see the same file but it is microsoft access file type.i am looking for master file.....
i found the botsched in this directory:C:\ibi\DevStudio76\srv76\home\catalog
not in th one which you mentioned above,but the file is of ms access not a master.This message has been edited. Last edited by: swati,
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
When you create the synonyms from the web console, you will be asked what directory to put them in. You will only be able to select a directory in ibi/apps that is in your profile.
Once you write your program, put an APP PREPENDPATH in your program pointing to that directory so that when the job runs, particularly if it is running under another execution id, it will be able to find the BOT masters.
Ginny, when i am trying to create the master using the synonym editor,i am facing the following problem i .e;i need the following credentials: i have to fill these three rows:-- 1.restrict object type to 2.further restrict search to. 3.filter by owner/schema and object name.
kindly help me what i need to fill over....
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
Those are options to filter the list of returned available table to create synonyms. NOTE if you are using a DBMS for your repository such as MSSQL Server and you do not have the MSSQL Server Adapter you will not be able to create the synonym. you could filter the schema buy placing a BOT% in the filter by schema box.
HEY, I AM USING THE TERADATA D/B,when i enter the BOT % under the filter by schema i cannot get the table,i can only see that objects not found screen. please tell me how i can create the masters i.e; synonym for BOTSCHED table so that i can query the master and schedule it...?
if you cannot understand my question let me know plz,will explain clearly........
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
Hey ginny, i have three adapters like oracle,teradata and sql ,but not sure whether report caster repositary is in the tera data.so i want to know how do i know in which adapter the report caster repository is in..? and when i try to create a synonym using the synonym editor it populates the screen to filter,i need to pass through this screen to get the next step so i have to use the filter....
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
If you don't even know which repository ReportCaster is using you probably should not be creating synonyms for the RC tables. Are you and admin for ReportCaster/MRE? What your are wanting do do should noly be an admin-type user function. Usually the admin has a little more information about how the environment is set up. It could also be that RC is only using a FOCUS repository, and not any of your listed databases.
The ReportCaster configuration tool will tell you what db is used for the repository.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
HEY , i am a jr wf developer,i am trying to create a RC report that is sent to me when a user schedules a job..?please tell me what are the steps.so that i can finish the task accordingly... i am pretty new to Report caster. i want to know the process of creating the synonyms to the BOT tables so that i can progaram them and alert them...This message has been edited. Last edited by: swati,
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
ok,what do u mena by REPORT CASTER COPY.i can acces the RC from my pc but when i access the the REPORT CASTER libraray and REPORT CASTER console,i get an error that insufficient privilages...
7.6.7 windows PDF,EXCEL.
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009
Swati, do as Darin says and talk to your WebFOCUS adminstrator. He can tell you about how WebFOCUS and Report Caster are installed at your site. We have to know where the parts are in order to help you or we are all wasting our time. So, go talk to that person and get the scoop and then tell us where the WF reporting server is, where the Report Caster distribution server is, and what kind of data base is being used for the RC respository.
And if you don't have access to RC, you are not going to be able to accomplish your task. So, go talk to the admin.
I don't mean to rain on your parade, but if you're a developer and not the admin, I would expect that your admin is NOT going to allow you to go rummaging through the raw ReportCaster tables. There is information there that should not be accessible except to an admin. You could also do some irreparable damage. That's why access to those tables is not part of the install/config process.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007