Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi All,

In this article, I will be providing all the perquisites and details that are required to Automate scheduling in BusinessObjects 4.1on Windows platform. These details are specific to scenarios when we are using network drive to trigger file event as well as export the schedule instance.

Overview:  File based event triggering is most commonly being used in automating the scheduling in BusinessObjects (BO) once loads are completed in BW. In this example below mentioned workflow is defined to automate the scheduling:


Workflow explanation:

1: When Scheduling is configured as mentioned in implementation steps in below section, Report schedule immediately goes into pending status.

2: Event server monitor the location set in file based event for dummy text file.

3: As soon as File is created and Event server detects that, it notifies Central Management Server (CMS) server and file based event is triggered.

4: When File event is triggered, report schedule runs and export is sent to the specified destination.
5: Schedule success or failure will trigger Schedule event.

6: Schedule event triggering will execute Program file and dummy file is deleted from shared location. Dummy file create on file server has been deleted, so that  for next load completion, event can be triggered for new dummy file generated.

7: As recurrence is set for daily, schedule again goes into pending status and wait for new load to complete and dummy file to get
generated.

Prerequisite:

1: User ID with which BusinessObjects services are running on server, must have full access on Network drive where dummy file is placed by BW loads and Exported files from BusinessObjects schedule needs to be placed.

Ex. If Server Intelligence Agent (SIA) is running with Domain user, then that Domain user must be have full control on shared location on file server where dummy file is placed by BW loads and Exported files from BusinessObjects schedule needs to be placed.

Refer: 1219698 - Event server not triggering an event when a trigger file is created onnetwork

2: Add domain user account to the following policy to schedule the program object successfully.


a. Replace Process Level Token Policy.

b. Log on as a batch job.

c. Adjust memory quotas for a process.

d. Access this computer from the network.


Refer: 1918082 - A scheduled Program Objects fails with error "The Program Object reported an error while running, but no error code was provided" in BI 4.0.

3: Adaptive job server must have destination type as file system included.

Steps to implement:


1:  Create a file based event  Z_File_Event in CMC with below mentioned parameter:


Server = <BO server name>.<Event Server Name>

Folder=  \\<File server name> \<folder name>\Loads_complted.txt


Where Loads_Complted.txt is a dummy file name.  This file will be placed by BW in above mentioned shared location once loads are completed.

2: Create one more event as  Schedule event, named as  Z_Schedule Event in CMC.

3: Add a Program file in repository to delete a dummy file created by BW from shared location as mentioned below:

Create a Windows batch file named “To delete dummy file.bat” with below mentioned content on your machine:

DEL <File server>\<Folder Name>\Loads_complete.txt

Upload the Program file to repository as shown in screenshot.


4: Now, schedule a report, let’s say in our case “Charting Sample.wid”

5: For scheduling setting, Set recurrence as daily for daily data load.

6: Destination:  To set export on shared location, set parameters as described below:

User name/Password: it will be the user name and password of the user that has access to the network share.

Ex: User Id: Domain\<User name>

      Password= <Domain Password>

Directory will be the fully qualified domain name path of the shared location.

<File server>\<Folder Name>\

File Name = Name you want to give to the scheduled instance


7: In the Event section of Scheduling settings, select event to Wait for Z_File_Event and Events to trigger on completion Z_schedule Event.Refer Screenshot:


8: Click on schedule.

9: Right click on Program object “To delete Dummy file.bat” and select schedule.

10: For scheduling setting, Set recurrence as daily for daily data load.

11:  In the Event section of Scheduling settings, select Event to wait for “ Z_Schedule Event”.

12: In Program Logon section, enter userid and password that has full access on shared location where dummy is placed.

Ex: User Id: Domain\<User name>

      Password= <Domain Password>

13: Click on Schedule.

Important: BusinessObjects Scheduling must be implement prior to dummy file is placed in shared location. Schedule will  be trigger only after file is created, not for the existing file.

Once above mentioned steps are implemented and new load is completed,  a dummy text file will be placed by BW to the shared location and schedule will start in BusinessObjects. Dummy file will also be deleted automatically after schedule is completed. In thi way scheduling is completely automated.


Thanks,

Manveer Nakoti

BO Consultant

Accenture

23 Comments
Labels in this area