Conditional Scheduling of Web Intelligence Reports

  • by Uladzislau Dauzhenka, SAP Solutions Organization Consultant, EPAM Systems
  • Syargei Rassadzin, SAP Solutions Organization Consulting Team Leader, EPAM Systems
  • February 17, 2016
Learn how to implement SAP Representational State Transfer (RESTful) Web Services within SAP BusinessObjects Data Services jobs to organize email delivery of reports that meet certain conditions and to prevent empty reports delivery.
Learning Objectives

After reading this article, you will know how to:

  • Schedule SAP BusinessObjects Web Intelligence documents using if–then–else logic
  • Use SAP RESTful Web Services within SAP BusinessObjects Data Services (BODS)
  • Work with a user-defined transform (UDT) and Python Expression Editor in SAP BODS
Key Concept
The standard SAP BusinessObjects Enterprise scheduler tool does not allow the creation of schedules with conditions. With the help of SAP BusinessObjects Data Services (BODS) and SAP Representational State Transfer (RESTful) Web Services, the standard scheduler can be enhanced with if–then–else logic according to the company’s needs. For example, the enhanced SAP BusinessObjects Enterprise scheduler enables you to send emails to stakeholders if marketing costs exceed 10 percent of costs. It also prevents an empty error report from being sent unnecessarily.

The standard SAP BusinessObjects Enterprise scheduler is a user-friendly tool, but, in some cases, it does not provide enough flexibility to satisfy companies’ needs. Email delivery of regularly scheduled reports makes sense only if these reports are not empty (e.g., error reports that are automatically generated, but actually do not contain meaningful data—in other words, no errors occurred during the data-quality check process).Otherwise, such emails waste peoples’ time. This situation is similar to reports that are much more interesting to stakeholders if certain conditions are fulfilled.

With the help of SAP BusinessObjects Data Services (BODS) and SAP Representational State Transfer (REST) RESTful Web Services, the standard scheduler can be enhanced with if–then–else logic to prevent empty reports from being delivered or check to ensure that conditions are fulfilled. We show you how to create BODS jobs with a user-defined transform (UDT) that is able to send REST requests to refresh Web Intelligence (also known as WebI or WEBI) documents, check if they contain data or fulfill conditions, and then schedule them. This article is intended for technical users.

In our example, we create a simple SAP BODS job to schedule documents only if they contain data. To do this, follow these steps:

  1. Prepare a list of document IDs for scheduling
  2. Create a job and the required underlying objects in SAP BODS
  3. Develop Python script for a UDT to send REST requests to the SAP BusinessObjects Business Intelligence (BI) platform and implement if–then–else logic
  4. Schedule the job to execute automatically when required

Uladzislau Dauzhenka

Uladzislau Dauzhenka is a consultant for the SAP Solutions Organization at EPAM Systems. He has more than 2 years of experience in IT technologies, including experience in development, implementation, customizing system settings, and support of SAP BI products. His main focus is reporting, SAP BusinessObjects, SAP BW, and SAP HANA solutions.

See more by this author

Syargei Rassadzin

Syargei Rassadzin is a consulting team leader for the SAP Solutions Organization at EPAM Systems. He has more than 10 years of experience implementing SAP BI products and more than 14 years of experience implementing SAP Business Objects products. In addition, he has more than 17 years of experience in consulting, software development, and testing. An SAP-certified application associate and certified project manager at the International Project Management Association (IPMA) level C, his main area of expertise is data warehouse design and reporting with multiple back-end systems (e.g., SQL Server, SAP NetWeaver BW, and Oracle).

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.