This is a step by step guide on how to broadcast a BEx report to the E-mail of specific users.
1) Open the BEx query in BEx Query Designer.
2) Go to Menu “Query->Publish->” and Click on “BEx Broadcaster”
3) Internet Explorer (or any default browser) window will open with a login screen for the “SAP NetWeaver Portal”
4) Login using the BW login credentials of the User using which you want the BEx report to be broadcasted.
5) You will see a screen as below which shows the list of available broadcast settings for the particular query:
6) Click on “Create New Setting” button.
7) There will be four tabs
a. Recipient(s)
b. Texts
c. General Precalculation
d. Filter Navigation
Recipients
You have different options for entering recipients:
Note: If an e-mail address for a user that you have specified under User or User in Role has not been maintained in user maintenance, the user will not receive the distributed file as an e-mail. Instead the user gets a message in the Business Workplace (transaction SO01).
Texts - Here you can make the following entries:
General Precalculation
Filter Navigation
On the Filter Navigation tab page you can specify characteristics or a control query so that the system precalculates several documents with different filter settings from the same query or Web application. These filter values provide you with a navigation option in the precalculated document. You can select the filter values using dropdown boxes in the navigation block.
You can make the following settings:
😎 Give a description for the broadcast setting
9) Select the Distribution type. In our case it would be “Broadcast Email”.
10) Select the output format. We will select “XML (MS Excel)” which is the Microsoft Excel Format.
11) We can enable the “As ZIP file” checkbox to send the file as a zipped attachment to the recipients email.
12) Recipients: Specify the email addresses of the users to whom you want the report to be broadcasted in the “Email Addresses” field.
13) Texts: Specify the Email “Subject” and the Email “Contents”. The subject and contents specified here will be reflected in the Subject and contents of the email delivered to the recipient.
14) General Precalculation: If the query has any input variables, you will have to create a variable assignment and assign values for the variable. The broadcasted report will be precalculated for the variable values which you assign in this tab.
Select VAR_01 as shown in the below screenshot and click on “Create”.
You will see the variable screen where you have to assign values for the variables and click on ok. (Sample variable assignment shown below)
15) The Filter Navigation tab is used to apply filters (if any) to the query before precalculating and broadcasting the query. We can leave it blank if no filters are to be applied before broadcasting.
16) Now save the broadcast setting by giving a technical name.
17) The next step is to schedule the broadcast after specifying the recipients, the contents of the email, and the variable assignment. Click on the “Schedule” button. Enable the “Create New Scheduling” check box, and select the time to schedule the broadcast and click “Transfer”.
Scheduling the Broadcasts Automatically:
The scheduling of broadcasts can be automated with the help of a program and through process chains. Create a process chain and include the ABAP program “RSRD_BROADCAST_BATCH”. This program can be used to schedule the broadcasts in the background without any use intervention.
Create a variant for this program and give the technical name of the Broadcast setting for the selection variable “S_SETTNG (Broadcast Setting)”.
Now schedule the process chain at the particular time (may be periodic) at which you want the broadcast to be sent.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |