Using SAP BusinessObjects dynamic recipient

SAP WebiSAPSAP Basis

In SAP BusinessObjects, you can deliver the reports as per business requirement. It is also possible to use dynamic recipient’s option to deliver reports to users based on their requirement or split reports based on different values of a characteristic.

Let us understand this with an example, let us say you have 4 specific regions in the report and you want the report to be delivered to individual Regional Manager for their respective region. You can use dynamic recipient option to make it possible.

To implement this, you need to create a dynamic recipient report by developing a webi report which contains Region name and email Id of Regional manager, etc. Following are perquisites while using publishing option in Webi

  • You shouldn’t have a prompt while executing your .wid report. If it is prompt you should set a default value of the prompt.
  • The basis on which report needs to be split for each user for example in this Region Id, it should be not available as prompt. It might throw the error after scheduling this as I have seen this behavior in BO 3.x version.
  • You should save the report by unchecking “Refresh on Open” option.



A dynamic recipient Webi report should look like this

Region_IdRegion_NameEmail IDUser NameSales_Amount
1EMEAjohn@abc.comJohn2450
2APACamit@abc.comAmit5000
3AMERAnne@abc.comAnne3500
4LAJason@abc.comJason600


You can refer to below link for more details:

https://blogs.sap.com/2013/09/16/webi-publishing-through-dynamic-recipients-and-issues-faced/




raja
Published on 23-Apr-2018 06:27:44
Advertisements