Business objects file event




















If one is running, it will retrieve the list of servers and their command lines including the local CMS if there is one and start them. When the CMS is initialized the SIA will retrieve the list of servers linked to it, along with their command lines and then start them except for the CMS which is already running. When CMS is Started:. It will then bind to the port and request ports defined or a random request port if it is not configured Auditing background operation: 1. Below is an example of file name generated by auditing Note that the first 5 files all start with the same string so they are generated by the same BI server.

No labels. John Clark. Permalink Jan 05, Rajdeep Marathe. Hi John, Once the contents from the files are pushed to the Audit Database, the file should be deleted from the Auditing directory. Custom Event:. File Event:. Scheduled Event:. Once after creation of the Events. We need to assign the security to the users to use these events.

Do a right click on the event and select the properties and then select the User security as shown below. Once after done with the security. Do a right click on the report and Select shedule. The followed screeb will appears. Click on the Events in Navigation pane to view all the events. Then you will see the instance status as Pending. It is waiting for the event to get triggered. Then come back and check the Instance status. In the same way you can use this triggered event as kickoff event for another shedule or Shedules.

Scenario 1 : Let say we want to create file based event with file patterns. File name is appended with date and i want to schedule the report based on that file? Unfortunately, no. For File Events, the Event Server just looks for the presence of the file after it has been absent for at least one cycle of the Event Server — it does NOT look at the contents or date stamp of the file and the file must always have the same name. Scenario Let say a webi report scheduled to start at say 9 AM every day when a text file is created on the shared drive.

I have enabled the Notification email setting to receive both the success and failure emails. Since this is a recurring job scheduled the report to run every day for the next 2 years the report runs everyday at specified time and looks for the file. If the file arrives in the specified destination the scheduled job runs for that day and send a success notification email. For example, you can:. If you modify a scheduled report, BusinessObjects will run the modified version at the scheduled time s.

Note to Financial data set users: To streamline your report for scheduling, replace query prompts with report objects such as Today's Date, Previous Accounting Period, Current Fiscal Year and more, in combination with calendars such as Month End Close.

Run object Drop-Down List Screenshot. Recurrence Menu Screenshot. Prompts Menu Screenshot. Destinations Menu Screenshot. Note: The History window displays. To return to the list of reports in the current folder, close the History window.

View Report History To access a report's history, right-click the report title and select History. Note: The Last Run column displays the last time a scheduled report ran. Click the link under Instance Time or Title to view a specific instance run of a report. Great article..!! It is based on two events i. Once two events are updated in server,The event will be triggered in BO.

But issue is,Once first text file is updated in server,automatically the event is triggered without the second file update in server.

Because of this schedule got failed. Can any one tell,how to trace out the event based schedules. Is there any log files or anything we can enable to trace out this issue.??? Thanks in Advance. You can enable traces on the Event server by appending -trace in the command line parameter in the server command line properties - and restart it once, then find the logging folder - the logs should generate there with this server name.

I tried to reproduce your case, but not able to Iam the beginner in this field. Thank you. Once data load is completed. But the report is populated with no data and when we refreshed the report manually it is fetching data. In the log file it says input contained no data. Can you please help me here if you ever run into the same issue.

I suggest, do a fresh scheduling of the same report and see.. It's possible, once the loads are completed, place a text file in a shared path, and define the file event in BO on this file.

Using process chains if we need to create text file, its possible only in AL11 Application server level. For a recurring scheduled job that waits for the file based event to occur, is there a way to receive a failure notification email if the file that the report is waiting for doesn't arrive on that day. I have a webi report scheduled to start at say 9 AM every day when a text file is created on the shared drive.

Obviously, I'm using a file based event here to trigger the scheduled job. I have enabled the Notification email setting to receive both the success and failure emails.

Since this is a recurring job scheduled the report to run every day for the next 2 years the report runs everyday at specified time and looks for the file. If the file arrives in the specified destination the scheduled job runs for that day and send a success notification email. If the file doesn't arrive for whatever reason on that day then the scheduled report will not run, but I will not receive a failure email notification either because the report never failed since the expiry date on the report is set to 2 years from today.

My requirement is that when the file doesn't arrive after certain time on a given day eg:- if the report instance starts at 9 AM and the file doesn't arrive by 11 AM then I need to send a notification to the users that the report failed to run. Is this possible or is it a limitation in BO? They simply drop a file at the location that my report will be looking. I think they will get notified if the data load fails but it doesn't come to me.

This way, you got the email notification you need as well as all other folks to whom are concerned. Thanks Jin-Chong for the reply. I think what you suggested above would be possible and will have to go with it as there is no other alternative in the Business Objects that allows me notify users if the file doesn't arrive after certain time.

I will discuss this solution with the DBA's and hear what they have to say. Thanks again for your help! Our CMS is on Linux.

This may work to start the job, but the scheduler would not know if the job finished. Control-M works with it's own scheduling behavior. But if you want to control the schedules in Business Objects using Control-M, can be done via File event.

Is it possible to create file based event with file patterns. File name is appended with date and i want to schedule the report based on that file. Unfortunately, no. For File Events, the Event Server just looks for the presence of the file after it has been absent for at least one cycle of the Event Server - it does NOT look at the contents or date stamp of the file and the file must always have the same name. I have based triggering of my crystal report publication on two file events.

These file events are triggered from two different process chains. What I have noticed is that the publication is not triggered upon completion of both events but triggers on completion of either events. Does this mean that if we include multiple events in Events to wait for section it will perform OR operation rather than AND operation? I have a set 12 monthly billing reports that need to run after End of the Month processes have completed which takes about hours.

We are creating records in a table with a data time stamp after each of the 12 processes have successful completed. Is it possible to trigger a report once all 12 processes have successful completed using Events? I have been researching the knowledge base, blogs, etc. Any help on this topic would be greatly appreciated.



0コメント

  • 1000 / 1000