Dynamic Webi Publication bursting to multiple email ids
Scenario:- let’s say an webI report that has multiple sections based on ‘Product Hierarchy’ or any other key field. That report need to be published to different distribution list depending upon the Section. i.e if the report has 30 different Types of ‘Product Hierarchy’ and each product Hierarchy has multiple users. In this case it will be very difficult to maintain the distribution list and every time need to update the scheduled publication. Because we need to create 30 publications and each publication will be addressed to a particular distribution list. If there is any change in the distribution list, then we need to update the respective publication which is very time consuming.
In order to avoid this situation, we have to go for dynamic publication. These are the below steps to be followed.
- Create an excel sheet in this format
2. Create webi report using the excel as personal data provider
4.In this step make sure Recipient Identifier and Email field has exact same value mentioned in the excel (Product Hier1 and Emails resp. in our case)
6.We can have dynamic values in email, subject, attachment name etc.