Hi all
Is it possible to change the Access Options for Report Library in RC Schedules from 'Owner' to 'Public' - I have 100s of RC schedules and I'd like to change the access option to Public for all of them.
I know that it is possible to change the owner of all schedules using Report Caster Global Schedule Update tool. I want to go a step further and change the access option as well.

Please advise!

Thanks
Syed

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

As far as I know, you can't do that. If we have a group of users who need to access the same schedules, we create a group id and have then create all of the schedules under that id.

Would something like that work for you?

Thanks Ginny.
Our users would not be using (modifying etc.) the schedules. Rather, everyone would like to see the reports that get generate in Report Library.
If access option for a schedule is set to 'Owner', only the owner of the schedule gets to see the report.

Hope this makes sense.

I went through the Report Caster help documents. As mentioned by Ginny, it is not possible to change the Access options for RC Schedules from 'Owner' to 'Public'.
To me, this looks like a very basic option that IBI should provide in future releases (not sure if this is present in 7.6.x or later?).
There are other options that I would love to be in report caster tools - for example- changing the distribution option of all schedules created by Report Caster, etc.
Not sure if others are also facing similar issues. Could this be brought to IBI's notice ?

Thanks
Syed

If you want to bring something to IBI's notice, you open a case and ask for an NFR or New Feature Request.

One of my favs is to allow to change the owner of a single schedule as opposed to all of the schedules.

Sure. Thanks Ginny. I might end up doing that, since it sure would give me an easy way to do what I want to.

By the way, may I ask why would you not use Report Caster to change the owner of a single schedule? I mean, we can change the owner of a schedule from Report Caster itself ! Or am I missing something?

Thanks
Syed

You can change the owner designation of ALL the schedules for a particular owner to another owner. However, you cannot change the owner of a single schedule. This could also be accomplished by be able to 'clone' or copy across owners.

I have not yet opened cases on these wants and desires.

Gotcha!
Let me see if I'm able to get a case opened.
Will keep you posted.

Thanks for the advise !

Syed

Hi
We were able to change the Access options from 'Owner' to 'Public' for all our schedules manually. Since it was a one time activity, we thought of doing it and complete it rather than going the IBI NFR route.
All set now!

Thanks for your inputs.

Syed

Why don't you check BOT*** tables. All the report caster stuff gets stored in BOT** tables.
I think you can write a simple Sql Update script.
We have recently implemented IBI in our office and I read these tables while implementing report caster.
Hope it helps!!!

great idea DD!
I am trying to access BOT** tables. Here, the RC info. is stored in FOCUS database. I was able to find the .mas files for these in //ibi/7.1.7/ibi/srv71/home/catalog/botsched.mas

Now I need to get the FOCUS files for these so that I can modify the relevant records.

Any pointers where I could find the FOC files?

Thanks

They might be in ..../wfs/catalog.

Looked into /ibi/7.1.7/ibi/srv71/wfs/catalog, but the BOT*** FOCUS files are not present in this dir.
Found the following files though:
focussu.foc
ibitrace.fex
inu.log
psprcs00.t3i
pssecsnk.t3i
syscolln.foc
syscollt.foc
sysrpc.foc

I guess I'll need to stop FDS and then run a utility to create the BOT*** FOCUS files.

http://documentation.informati...wf71_win_install.pdf

I'll update the post if I;m able to access the FOCUS files.

Thanks

As it turns out, we have Oracle tables which are being used to store data related to BOT***.
I've asked the team to set up data adapter so that I may access these tables.

Hope it works this time !

Thanks
Syed