Skip to Content

Introduction

SAP Business Objects Financial Information Management is a web-based ETL Tool. The financial information management tool provides a user friendly interface on the top of SAP Business Objects Data Services. It allows the user to maintain mappings between source and target. A FIM job is a series of steps that loads data from a source to a target.  When a financial information management job is created, it can be run immediately or via an external scheduling tool such as Windows task scheduler. This document deals with scheduling a FIM job using BODS scheduler.

Scheduling a FIM job

                When a financial information management job is created, it can be executed immediately or via an external scheduling tool such as Windows task scheduler. This document deals with scheduling a FIM job using a BODS script. A scheduling file has to be generated that contains a command line to launch Internet Explorer on a given URL. The scheduling file gives information on the selected job, the execution parameters, and the user credentials.

Step 1:

Save the FIM job as a scheduling file. A scheduling file contains a command line to launch Internet Explorer on a given URL. The scheduling file gives information on the selected job, the execution parameters, and the user credentials.

/wp-content/uploads/2014/10/a_561241.png

 

Step 2

Enter the login credentials. A message is displayed informing you that the scheduling file for the job has been generated.

/wp-content/uploads/2014/10/b_561431.png

Step 3

Download and save the scheduling file.

/wp-content/uploads/2014/10/c_561432.png

/wp-content/uploads/2014/10/d_561433.png   

A VB script gets saved.

 

Step 4

Place the generated VB script file in the Data Services installation folder in the job server machine. This has to be placed in – \\SAP BusinessObjects\Data Services\bin\ – path.

Step 5

          Login to BODS designer to create a BODS job.

/wp-content/uploads/2014/10/a_561241.png

Create a project named schedule.

/wp-content/uploads/2014/10/b_561431.png

Create a job named Schedule using ‘New Batch job’ option.

/wp-content/uploads/2014/10/c_561432.png

/wp-content/uploads/2014/10/d_561433.png

Add a script object inside the batch job that has the script to execute the vb script.

Print(‘ VB script execution triggered –‘ || exec(‘cmd’,’Job1.vbs’,8));

/wp-content/uploads/2014/10/e_563023.png

/wp-content/uploads/2014/10/e_563023.png

Step 6

The job Schedule_Job can be scheduled through DSMC to run the FIM job. To create the schedule login to data services management console and add schedule on the Schedule job.

/wp-content/uploads/2014/10/f_561444.png

 

Step 7

Create schedule for the job and activate it

/wp-content/uploads/2014/10/g_561445.png

This schedule will run the Schedule_job at the specified time.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply