Scheduling Webi Report multiple times daily
we have a webi reports based on oracle table.By using ETL Job data is loaded in to oracle tables daily (multiple timings) .
my requirement is i need to schedule this report after ETL JOB ran successfull.
If ETL Job runs daily once or in a specific time i can schedule this report using Event (using Recurrence).
But ETL job runs multiple times in a day.
Whenever ETL job finished my report report should schedule .
Srinivas Ganapathi replied
You could use File based events. i.e. create a file when your data is loaded, have BO monitor a specific directory for a specific file. Once that file is available, the report be scheduled. Note that BO will not delete this file.
You will need to come up with a system to delete this file. You could use Program Job based on a successful report schedule to delete the file though.