Dynamic Recipients get multiple mails with bursted reports

scheduling XI Scheduler
1

Hi,

we have a report that should be send to different emailadresses with different content bursted by department number.

We created a list of dynamic recipients containing departmentnumber, username, emailadress. One user may be part of several departments. Emailadresses and usernames are not part of the report.

For example:
departmentnumber, username, emailadress
dep_01, Mr. One, one@abc.com
dep_01, Mr. Two, two@abc.com
dep_01, Mr. Three, three@abc.com
dep_02, Mr. One, one@abc.com

Now I have two possibilities for Dynamic Recipients:
(a.) I choose username as Recipient Identifier:

  • Four emails are generated.
  • Mr. One gets two emails, one with a report containing data from dep_01, one with data from dep_02.
  • Mr. Two and Mr. Three get one email.

(b.) I choose departmentnumber as Recipient Identifier:

Bursting works as expected.

My problem is, that we have many departments and e.g. Mr. One is not amused when he gets ten or more emails with the same report.
Is it possible to get

  • one email for each user containing one report for each department or
  • one email for each user containing one report filtered on all departments of the user?

Do I have to rearrange the Dynamic Recipient List? How does it have to look like?

We are using 4.1 Support Pack 6.

Best regards

mwies (BOB member since 2016-02-05)

2

I don’t think so. You’ll have to maybe create a new variable in your report that amalgamates all Mr. One’s departments into one identifier, then use that to determine dynamic recipients. That way he would get one email with one report filtered on all his departments.

peacha :uk: (BOB member since 2008-07-31)

3

We achieve similar customized bursting via SDK. We store in a database, the (using your example) the profile of “Mr. One” , which would be his details (i.e. email_addr) along with all of the departments that he’d be associated to. Our java program would then execute, query the database and for each user, it would create a ‘run-now’ instance of a given report, passing in all of the department prompt values for “Mr. One”, thus generating one sole report with all of his information. This process would then repeat for all of the other recipients.

jresendez :mexico: (BOB member since 2004-05-03)