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.

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Ignacio Pastene

    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

    (0) 
    1. Javed Chowdhary 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.

      (0) 

Leave a Reply