Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Join / Log in
Hi,With bursting, there are two pieces to configure. The "Burst Groups" section controls how the report gets chopped up into individual outputs. It looks like currently you are creating separate outputs for each value in the Account item. To get separate outputs for each customer, you'd need to use an item here that uniquely identifies each customer. The second piece is the "Burst Recipient" section. This controls where the different outputs get sent to (and/or saved to - you can also burst back to the portal for users to view manually, rather than emailing). Currently you are using your Branch Email item to define the email addresses to send to, which sounds like it's correct based on what you are describing.When running or scheduling the report, it's also important to remember to check the box to enable bursting as the report runs.Cheers!
If your burst was configured correctly then it should already be sending emails with only the data intended for that recipient. I noticed in your screenshot that you never defined a Master Detail Relationship or Label which is probably why it's sending everything to everybody. I'll give some steps here that you can compare against your end to see if it's configured correctly. In my approach, I'm using two entirely different queries (one for the data to send and another with a master list of all the account codes and their emails). In your example, you may be able to do all this using the same qReportList query as long as you join them as shown in the steps below. But read below and you'll get a feel for it.
Now when this report runs, it should only be sending the data to each email address already tailored to only THEIR data (ie. your account codes). If there is data in your Query2 for an account code that doesn't exist in Emails for Bursting query (or maybe it's there but the EMAILS column is empty when it finds it) then it will not send any data for that particular set of email addresses (but it will still burst to all others). Hope this helps. Görüşürüz!