command line automation

scheduling XI Scheduler
1

We are using BO XIR2 in our production environment (windows xp). We use Perl/dbi on a Unix machine to create Oracle 10g tables each morning. Once the Perl script completes and tables are created, we manually run the webi report. Is it possible to envoke a webi report from our Unix server so that we can fully automate the process (maybe wrap it in Perl)?

Thank you, experts!

jodugg :us: (BOB member since 2007-12-18)

2

Hi,

Check the event-based scheduling of reports.

In a nutshell:

  • at the end of the Perl scripts execution, have it to create a file on a network shared folder
  • in BOE, set up an event that will be “waiting” for the file to appear in the shared folder
  • schedule the BO report to be refreshed based on the above event

Please read more details in the scheduling guide.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

I don’t know about automating report scheduling directly (from another system/program), however here’s one possible solution:
[list]

  1. Have your Perl script create a file, either on the Unix machine, but preferably directly on the BO Server’s filesystem.

  2. Create a File-Based Event in BO CMC. Making sure you specify the full path and filename to the file that was produced by your Perl script.

  3. Schedule your report to run based on the event above being triggered.
    [/list]
    If you need more help, then please refer to the following sections in the BO Administrator’s Guide (CMC help):

  • File-based events
  • Scheduling an object with events

HTH,
Pete

Peter Hughes :uk: (BOB member since 2005-11-21)

4

Wonderful suggestions. THANK YOU!

jodugg :us: (BOB member since 2007-12-18)