Applies to:
SAP BI 7.0. For more information, please visit the Business Intelligence Homepage.
Summary
The article provides an insight to Information Broadcasting and its significance in industry. It provides an overview of the various broadcasting options available and illustrates the broadcasting of a report to users via e-mail.
Author: Debashish Pattnaik
Company: Tata Technologies Ltd
Created on: 12 March 2012
Author Bio
Debashish Pattnaik is working with Tata Technologies Ltd as a SAP Functional Consultant. Debashish has got a work experience in SAP Business Intelligence and SAP ABAP.
The basic idea of information broadcasting is to make BI reports available to a wide spectrum of users. This allows the distribution of BI information via various channels in different formats to the right people at the right time. A broadcast can be configured to run
The sales users want to track the weekly sales growth. They may wish to receive the sales data on Monday morning. The data can be broadcasted to the users via mail based on authorizations; plant wise, sales organization wise, etc.
Step 1: Go to Query -> Publish and choose BEx Broadcaster. It opens the portal link for broadcast settings.
Step 2: As the portal is accessed through BEx Query designer, the object type is automatically selected as query.
Otherwise different options are available to be chosen from.
Step 3: To start with, click on the button “Create New Setting”. The setting screen appears as shown in the screenshot below.
Step 4: Change the description to suit your Broadcast setting purpose. You can also select the distribution type from the available options. Other available options are:
a) Broadcast to the Portal :
b) Broadcast to the Printer:
c) Broadcast E-Mail(Bursting):
d) Broadcast according to Exceptions:
e) Broadcast (Multi Channel)
f) Precalculate Value set
g) Fill OLAP Cache
h) Fill MDX Cache
Distribution Options:
This document concentrates only on E-mail broadcasting option.
Step 5: The E-Mail broadcasting can be done in various output formats which includes MHTML, XML, HTML, Online Links to Current Data and PDF.
The output format HTML enables that components of HTML page are generated by the system in individual files. Recipients can navigate between different filter views of the query. The MHTML output format generates a HTML page with all the components (HTML, style sheet, pictures, etc.) in one file. Recipients cannot navigate in the generated file.
When the “As Zip File” checkbox is checked, it’s ensured that it’s the most secure method for protecting the access to your data. However, the recipient must have online access to your system, a username, and password.
The recipient may not see the same as what you believe you sent, since the data may have been refreshed since you sent the broadcast. To view the latest data, an e-mail could be sent with the link back to the online source (requires recipients to log on to see the content).
Step 6: Now, the recipients of the mail have to be defined. Recipients can be mentioned in various ways:
Step 7: Subject and body of the email can be framed through the Texts tab. Even the importance setting of the mail can be chosen from the drop down list.
Step 8: In the general precalculation tab, following features are available:
Portal Theme: The theme to be used can be specified by selecting one from the available list. The theme defines the appearance of control elements, font size, colors of the precalculated BI object.
Only Upon Data Change: Once this is checked it ensures that the document is distributed only in case the document has been changed since the last distribution.
Excel 2000 Format: This option appears only when the output format is chosen as XML (MS Excel). If this is selected, the system creates the document in Microsoft Excel 2000 format. Otherwise, Microsoft Excel 2003 format is created by default.
Variable Assignment: Values can be assigned to the query’s input-ready variables (variables defined during query creation). The query is precalculated using these variable values. These variable values are set whenever an online link is opened.
When the option “Online Links to Current Data” is chosen as output format, we can find a “General Link Generation” tab instead of “General Precalculation” as was available earlier with other output formats. The “Ignore” button is preselected which indicates no variable assignment for the query. Values to variable can be assigned by selecting the “Determine here” option. The assigned values of the variable are appended to the url of the online link. The query is started with these variable values whenever this link is opened.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Subject | Kudos |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
User | Count |
---|---|
11 | |
10 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |