Blogs / SAP / SAP BusinessObjects / Schedule Web Intelligence Reports using Publication

Schedule Web Intelligence Reports using Publication

Jan 27, 2020

SHARE

This blog explains the steps necessary to create and schedule a publication for dynamic recipients on SAP BusinessObjects Enterprise for a WebIntelligence Report. With this feature, the users want to keep track of certain KPIs for their areas of supervision. We have used the scheduling feature of BOBJ platform called Publication to meet this requirement.

The publication provides the feature to distribute reports to individuals or group of people as per their need. The business information can be sent to the email or BI Inbox. The information can be personalized according to the user’s requirements and can be sent at a scheduled time.

Dynamic Recipients

To send the reports to a dynamic group of recipients, a web intelligence report will be used as the source of recipients. We developed a HANA model on the below table which lists all the recipients, their roles, email ids and areas of supervision. USER_IDENTIFIER field is the concatenation of Email Id and roles (USER_GROUP). This field is used as a unique identifier to get personalized information for the users.

Schedule Web Intelligence Reports using Publication

A web intelligence report is built on this calculation view which will be used as the source of ‘Dynamic Recipients’.

Schedule Web Intelligence Reports using Publication

Source Document

In this section, the web intelligence report is selected which consists of information that needs to be emailed to the users.

In the calculation view which is used for the source report, we have made a join with the Distribution list table and KPIs model so that we get data at the user level filtered for those areas which fall under their supervision. (This step is not necessary if the user roles have been set up on the BOBJ side. We are using the USER_ IDENTIFIER field as a unique identifier for the data distribution so we need to get data at the USER_ IDENTIFIER level in the KPI model).

Schedule Web Intelligence Reports using Publication

The web intelligence report is built on this calculation view to show the visualizations which business users would like to see. This will help them to monitor the KPIs in their respective areas.

Schedule Web Intelligence Reports using Publication

Personalization

In this tab, the unique identifier field is selected in both the web intelligence reports – Dynamic recipient and source web intelligence report. This will filter the data in the source document to send only relevant and personalized information to the recipients.

Schedule Web Intelligence Reports using Publication

Destinations

In this tab, the configurations are made such as the destination (as in where we want to send the report such as BI Inbox, Email, etc.) message subject, body, and file name, etc.

Schedule Web Intelligence Reports using Publication

Prompts

Enter a value for the prompts for the source web intelligence report.

Schedule Web Intelligence Reports using Publication

With this feature, you can send personalized information in the required format to the intended recipients at specific intervals of time and deliver targeted business information to groups or individuals through a portal.

Learn more about Visual BI’s SAP Lumira Offerings here and read more related blogs from SAP Business Objects Category here.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!