Sap Bo Schedule To File System

Skip to end of metadataGo to start of metadata

BO uses the Adaptive Job Server process to run the schedule. The Linux system is sudo only,so l used the BO administrator credentials in All the Adaptive job server and jobserverwebi for the configuration. When scheduling the report l use specific name and add placeholder by selecting file extension, but NO username/pwd. Thanks All for your.

This document informs the reader how to schedule a program to run in SAP. The scheduling of reports in a very dynamic activity. A report can be scheduled immediately, or according to date and time, or dependent on another job.

AUDIENCE

All system maintenance personnel should review this document.

REFERENCES

For more information the following sources are recommended:

SAP On-Line documentation

PROCEDURE

A report can run with or without a variant. A variant is a file which contains the report’s parameters. These parameters are initially set to a default setting but can be adjusted by the user before executing the report.

If you wish to schedule a report to run that does not require a variant, follow this procedure.

1.) Go to System -> Services -> Background Jobs -> Job Definition which will take you to the Define Background Job window. Enter a Job Name and a Job Class for the job you are defining.

2.) To define a Start Time click in the Start Time box. Here the Start Time window will appear giving you the option to schedule a job immediately, with a defined Date and Time, After a Job, After an Event, or At an Operation Mode. All options are self-explanatory. This example will schedule a job according to a Date and Time. Click the Date/Time button.

3.) Input a Scheduled start Date and Time. The “No start after Date and Time” fields are optional. If this will be a periodic job click on the Periodic Job box at the bottom and then the Period values box. Click on the Period value you wish to run the job at Hourly, Daily, Weekly, Monthly, or Other. After scheduling the job, click on the Save button. The Job Start section of the window will have the Date and Time you selected.

4.) Click on the Steps button. Assuming you are scheduling a ABAP/4 program (report) to run click on the ABAP/4 button. This will allow you to enter the program name in the entry field. Since there is no variant you will not enter anything in the Variant field. Click on the Save button. This will bring you to the Step List which verifies the job you just defined. If all the information is correct backout of the screen (Green arrow).

5.) Once you backout of the Step List screen you will be at the Define Background Job screen. Click on the folder icon to save the job you just defined. You MUST do this to create the job. You will see a message at the message bar at the bottom of the screen indicating the job was created.

6.) To verify the job is released and scheduled go to System -> Services -> Background Jobs -> Job Overview. This brings you to the Select Background Jobs window. This window allows the user to search for a defined job based on the specifications defined by the user in the window. Thus, a user can scan all job names scheduled from a specific start time to a specific end time and SAP will return the results. Once the search parameters are defined press Execute and SAP will search.

7.) After SAP has finished searching it will take you to the Job Overview window. This window lists the jobs found for the parameters defined. Click on a job name and the Display button to review the details inherent to that job. This simply verifies when the job is scheduled and what program will be run. The Job Menu has more options you can conduct on the job.

Scheduling a report to run with a variant is done much the same way except a variant must be defined before the job that it will be used in is scheduled.

1.) Go to Tools -> CASE -> Development -> Program Maintenance -> ABAP/4 Development. This will take you to the ABAP/4 Program Development: Initial Screen. Enter the program name in the field provided. Click on the Variants button in the Object components box. Click on the Change button.

2.) This will take you to the ABAP/4: Maintain Variants window. To create a variant for the program you have indicated, enter a name into the Variant field in the Variant ID box then click on Edit. This will take you to the Maintain Variants For Report <name> Variant < name> window. The program parameters for the program you will run will be listed in this window, define them as necessary. Once you have defined them save the parameters. This will take you to the Report <name>: Save Variant window. This window lists the variant fields and gives the user the option to protect a field or not. To exit the window save again. This will bring you back to the Maintain Variants For Report <name> Variant <name> window. From here you can follow step one through seven for running a report without a variant.

3.) Please Note that Step Four says not to enter anything in the variant field within the Step 1 screen. You should enter the variant name that you created in the field, otherwise the program will not run.

This document will describe how to schedule Webi report output in CSV or custom format (PIPE).

Default options are available to schedule webi query data in CSV or export report data in CSV with CSV as achieve option.

• Default CSV format: This option in report scheduling enable to export webi query data in CSV (comma separated values) format. This option helps if all calculations are handled at database or universe level.
• CSV as archive: SAP introduced new feature from BI 4.1 to save as report data in CSV format with option CSV as achieve. This option enable the option to export report data in CSV format. But this is specific to report export. This is not available with report scheduling yet.

With the above two options the gap still persists i.e. how to schedule webi report output in CSV or custom format.

When is this helpful?

• If data is coming from multiple webi queries.
• If calculations are achieved by reports variables/report level filters.
• If expected format is other than that CSV. e.g. PIPE separated values.

Here I am taking data from e-fashion universe to demonstrate how can we schedule report data in CSV or custom format.

1. This is the report data which I want to schedule at File system or FTP location.
2. Create variable Var_Main.Sample like:Var_main =Char(34)+[Year]+Char(34)+”,”+Char(34)+[State]+Char(34)+”,”+Char(34)+[City]+Char(34)+”,”+Char(34)+[Store name]+Char(34)+”,”+Char(34)+[Sales revenue]+Char(34)+”,”+Char(34)+[Quantity sold]+Char(34)
3. Drag Var_main variable in report and update header as per required definition.
4. Export the report.
5. Right click and schedule the report.
6. Under the Format “select Plain Text”.
7. Under the Destination select destination (File system/FTP/Email) and add the title and manually add .csv in the use specific name. Uncheck the option “add extension”
8. Schedule the report.
9. Final output as:

Similarly for PIPE create another variable.

Sample like:

=” ”+[Year]+” ”+”,”+” ”+[State]+” ”+”,”+” ”+[City]+” ”+”,”+” ”+[V_Store Name]+” ”+”,”+” ”+[Sales revenue]+” ”+”,”+” ”+[Quantity sold]+” ”

Points to be noted:

• This option will only work if file delivery location is (BI Inbox/EMAIL/FTP/File System/SFTP server).This option will not work if default location is enterprise.
• SAP disabled the add extension feature from BI 4.2 and re-enabled from BI 4.2 SP03 Patch 8.Without add extension this option won’t work.

For more details check mentioned sap note.

2369625 – ‘Add File Extension’ option is missing for email schedule destination in SAP BusinessObjects BI Platform 4.2 SP3

Regards,

Amit

Would you like to access Full Article?

If you are already a member in this website, Please Click here to If you are not yet a member, Please Click here to

New NetWeaver Information at SAP.com