Dynamic Receipients Publication in Webi

[lucapearce]

Hello All,

I have a Report which is being used in Publication and the Dynamic recipients is mapped to Source report which has Customer Code and Email Address information and in the Personalization Customer Code is mapped to the Customer Code of the Actual Report to be published with the Customer code of the Source Report so that an email can be dispatched to the specific email address of that specific Customer Code.

Objective is to be able to get the refreshed data each time the data is updated in the Table that is used in the Source Report of Dynamic recipients, I have checked the option Refresh on Open for the Source REPORT , each time data is updated in the Table I need to run the Source REPORT manually and once it is success then I need to re map that specific instance of the Source Report in the Dynamic recipients section. and then re run the Publication then it is working

OBJECTIVE is to Run the PUBLICATION once the table of the Source Report is updated without having to re map the Source Report


Please advice a solution


Thank you