Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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.

 

Step 2

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

Step 3

Download and save the scheduling file.

   

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.

Create a project named schedule.

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

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));


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.

 

Step 7

Create schedule for the job and activate it

This schedule will run the Schedule_job at the specified time.

Labels in this area