Skip to Content
Author's profile photo Javed Chowdhary

Configure SMTP server in SAP BO and Schedule webi Reports for Email as Destination

Hi,

This document provide details on how to setup the SMTP server in SAP BO CMC and to schedule a webi report and send it to Emails directly.

Versions of Software Used


SAP Business Objects BI Platform 4 (Version- 14.0.6.1036)

Prerequisites –

  • Access to CMC (Central Management Console)
  • Rights to access Servers from CMC.
  • SMTP credentials needed for setup in server.(Can be obtained from admin person who handles mailbox in your organization).
  • Scheduling rights to the user to schedule the webi reports.

Steps-


Login to CMC

/wp-content/uploads/2014/01/1_357032.png

Go to Servers from Organize menu in CMC

/wp-content/uploads/2014/01/1_357032.png

A list of all the servers will come.

/wp-content/uploads/2014/01/1_357032.png

Select AdaptiveJobServer from the list.

/wp-content/uploads/2014/01/1_357032.png

Right click it and select Destination

/wp-content/uploads/2014/01/1_357032.png

In destination you will get a drop down , select Email from the drop down and click Add.

/wp-content/uploads/2014/01/1_357032.png

Click Email, a window will come with rows to enter the SMTP credentials, fill all the details .

* Domain Name

* Host

* Port  are mandatory.

You can enter Email ids for from and to/cc , the mail ids you will put here will get the scheduled report when you schedule it for Email as destination.

/wp-content/uploads/2014/01/1_357032.png

Also, you can use the Placeholders available to make subject ,message and name for your report.

Fill up all the necessary details and press Save or Save & Close.

/wp-content/uploads/2014/01/1_357032.png

Now, SMTP server has been configured.We will schedule a webi report with Email as destination.

Login to BI LaunchPad

/wp-content/uploads/2014/01/1_357032.png

Navigate to the webi report you want to Schedule.For my case its Test_Report

/wp-content/uploads/2014/01/1_357032.png

Right Click on the report and click Schedule

/wp-content/uploads/2014/01/1_357032.png

A new window will pop up with multiple options.

/wp-content/uploads/2014/01/1_357032.png

From Reoccurence choose the type of scheduling you want eg. Now,Weekly,Daily etc.

For my case its Now

/wp-content/uploads/2014/01/1_357032.png

If your report consists of Prompts than click Prompt option and click Modify, this will enable you to choose the prompt values for which you want to schedule the report.

/wp-content/uploads/2014/01/1_357032.png

Format, choose from the list of formats available i.e. Webi,Excel,Adobe Acrobat etc

/wp-content/uploads/2014/01/1_357032.png

In Destination option choose Email from the drop down.

/wp-content/uploads/2014/01/1_357032.png

Now, a new window with options will come which let you schedule the report for Email as destination.You can enter the details of emails here also but it will not be static as you have to put all the details every time you will schedule the report.

/wp-content/uploads/2014/01/1_357032.png

Choose Use Default Settings checkbox.Now this option will take the data from AdaptiveJobServer and will send the report to the Emails configured there.

So, this is a one time work as you can set all the emails at Server side and just click Default Settings for scheduling.

/wp-content/uploads/2014/01/1_357032.png

Once done click Schedule.The report will Successfully scheduled and will be sent to the Email Ids configured.

Regards,

Javed.

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good one...

      Author's profile photo Former Member
      Former Member

      Thanks for sharing

      Author's profile photo Former Member
      Former Member

      Thanks for sharing

      Author's profile photo Former Member
      Former Member

      Very useful and handy information.

      Thanks for sharing this useful information.

      Author's profile photo Former Member
      Former Member

      Very usefull document, but when i follow this instruction and enden the whole configuration, i have a problem with the Alias. When im sending the email from BO side, when arrives to my inbox it didnt come with the alias mail address (ex, jsmith@bbc.com, when the alias is "John Smith") How can i solve this? Thanks in advance. Regards, Ignacio

      Author's profile photo Javed Chowdhary
      Javed Chowdhary
      Blog Post Author

      Hi Ignacio,

      Please let me know what exactly the issue is, the Alias from which the mail is coming or the Alias to which mail is coming?

      Please clarify.

      Javed.

      Author's profile photo Former Member
      Former Member

      @Javed
      My problem is the Alias from wich is coming.

      Regards,
      Ignacio

      Author's profile photo Muhammad Bilal Barlas
      Muhammad Bilal Barlas

       

      Hi Ignacio,
      have you found any solution for your issue. I am getting same issue . kindly share the solution.
      Regards,
      Abuzar Ehteshamuddin

      Author's profile photo Former Member
      Former Member

      Hi Muhhamad.

      I dont found any solution yet.

      Regards,
      Ignacio

      Author's profile photo Abubaker Mohammed Raja
      Abubaker Mohammed Raja

       

      Hi All,

      is there any way I could schedule the job but the email should not go immediately as these email are addresed to key person and I dont want to send it to them when I am testing the schedule reports.

      Thanks

      Raja Abubaker

       

      Author's profile photo Former Member
      Former Member

      Hi Javed,

       

      Report running less than 2 min but when scheduling the report it keeps on running more than 20 min. Could you please help me to sort it out.

      Thanks,

      Author's profile photo Pravin Saive
      Pravin Saive

      Thanks Javed for the article this helped me and resolved my email schedule issue.

      I have another challenge, how to schedule the reports with auto increments of dates for e.g my

      todate should change daily.

      Author's profile photo Vijay Dhantapally
      Vijay Dhantapally

      Hello Guys,

      Can anybody tell us "What is the maximum file size for the publication email as destination in bo 4.1 or b0 4.2" .Please let me know which will be appreciated.

      Author's profile photo Frank Gwynn
      Frank Gwynn

      Great walkthrough.  Thanks.