Skip to Content
Author's profile photo Former Member

Using the Broadcasting Feature to Email Reports in SAP Business ByDesign

This blog provides instructions on how to automatically schedule and email reports in SAP Business ByDesign.

Why it Matters

How many senior level executives within your organization are using SAP Business ByDesign? How many of these are actively reviewing your sales, financials and operation reports in ByDesign? Typically the answer is “not a whole lot!”

In well-run companies, executives make strategic decisions based on data rich and easily comprehensible reports.Typically, executives have their teams provide reports on a daily or weekly schedule, manually pulled from the organization’s ERP system.

What if you could build a report, showing real-time data, delivered directly to your executive’s email on a daily or weekly schedule? Wouldn’t that be awesome?

In SAP Business ByDesign you can – and quite frankly, it’s pretty darn easy to set up.

What is Broadcasting in SAP Business ByDesign?

Broadcasting is a feature in SAP Business ByDesign that will streamline the information flow in your organization by delivering reports directly to any designated email address. Broadcasting reports by e-mail enables business users and decision makers to frequently analyze report data without having to access the ERP system and manually run reports.

Business Scenario

As the VP of Sales, I’m going to request one of my Sales Managers to build a Sales Order Volume Report to be sent to me weekly so that I can review it during our weekly sales meeting.

As the Sales Manager, your first step is to build/review the Sales Order Volume Report in SAP Business ByDesign. You would start by entering all necessary information required in the report, save the View and the Selection.

Sales Order Volume Report SAP Business ByDesign

Now that we have our report, we need to build the Broadcasting schedule so our report is automatically sent out on a weekly basis.

Access the Business Analytics WoC > Broadcasts.

SAP Business ByDesign Business Analytics Broadcasting

Click New

SAP Business ByDeisgn - New Broadcast

On the following screen, enter a name for the Broadcast and select the relevant report. In this scenario, this is where you select the Sales Order Volume Report. You’ll select your View and Selection later on.

New Broadcast

In the Channel section, enter a subject header and add a message. This will be the subject line and body of your email.

Channel

In the Recipients section, you have the option to check the Use Broadcast Bursting checkbox. When checked, this feature allows you to broadcast reports to multiple recipients by e-mail based on an attribute selected. Instead of explicitly defining the e-mail addresses of the recipients within the Broadcast you can define an attribute in the Attribute for Email field that allows the system to determine the appropriate recipients. In order to use this feature email addresses must be maintained in the system for the attribute selected.

For example, I could setup my Sales Volume Report to e-mail the ‘Employee Responsible’ a list of their assigned sales orders. The system would identify the e-mail address assigned to the ‘Employee Responsible’ and ensure it only receives the list of sales orders that employee has been assigned to.

Recipients in SAP Business ByDesign Broadcast

Unlike a normal Broadcast, the entire data set is not necessarily sent to all recipients. The report data is filtered for each recipient based on their e-mail addresses, identified by the values of the attribute you select. This ensures that every recipient only receives the data filtered for their e-mail address.

If you want to send the entire data set to all the recipients you can just create a regular Broadcast by unchecking the Use Broadcast Bursting checkbox.

In our case, we will just stick to regular Broadcast and add one recipient as shown below.

Broadcasting in ByDesign

Under Format and Content, select if the report is to be broadcasted as an attachment or as a link.

  • If you want to attach a report, use XML or CSV format.
  • If you want to send a link, use HTML or URL.

In our case, we will go with an attachment and use the CSV format. Now, this is where we specify the View and Selection we created for the report. The Zip checkbox option will allow you to zip the file. Let’s leave that unchecked.

Format and Content Broadcasting

In the next step, we determine the scheduling for the report. Since we know this will be a weekly occurrence, we select the Periodically radio button.

Scheduling in SAP Business ByDesign

When selected, the system will display the frequency options to create the schedule. Enter the following:

  • Frequency – type in 1 and select Week(s) from the drop down.
  • Start – Enter the start date and time for the report to be pushed out.
  • End Date – If there will be an end date to the schedule, go ahead and enter it here.
  • Day of the Week – Select the day you wish to send out the report.

Broadcasting Scheduling in SAP Business ByDesign

Here is the full view of the broadcast screen.


New Broadcast in ByDesign


Click Save and Close.


Once the Broadcast is scheduled and kicked off all recipients will receive an email. You can check the log and the last Broadcast run in the Broadcast View.

Broadcasting Log SAP Business ByDesign

The VP of Sales will now receive an email of the Sales Volume Report each week to be used for analysis and review during the weekly sales meeting.

Email Reports in SAP Business ByDesign

Hopefully this blog has shown how Broadcasting in SAP Business ByDesign can help you get easier access to critical data by automating reports and report distribution throughout your organization.

For questions or more information about SAP Business ByDesign please contact FMT Consultants.


Written by:

Brijesh Patel, Senior SAP Business ByDesign Consultant

FMT Consultants

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo M. Scheepers
      M. Scheepers

      Hi Jakob,

      Thanks for your clear description of the broadcasting process

      For me the normal broadcasting procedure works perfectly so no complaints about that part.

      What I struggle with is the Bursting mode. I have created a report with the Bursting mode 'on'. I also enabled an attribute that is filled with e-mailadresses of the managers (that need to see their employee's time statements). ByDesign give me a 'red indicator' when executing the Broadcast but only shows a message/log that the broadcast is started without any errors'.

      Do you have any tips/tricks to retrieve the error made?

      Kind regards,

      Mirko Scheepers

      Author's profile photo Clement Polizzi
      Clement Polizzi

      Hi Jakob and thanks for this tuto !

      If my case, I want to send a report which is a reminder to open the accounting period. With my view/selection, the report is empty if everything is OK.
      In such a case, do you know if SAP send an email with empty report, or does not send any email?

      I would prefer to send nothing if it is OK !

       

      Thanks in advance,
      Clément

      Author's profile photo Clement Polizzi
      Clement Polizzi

      Hi All,

      I performed some tests, and I confirm : if the report is empty, the email is not sent,

       

      Clément