RESOLVED: Bursting to Multiple Recipients in Burst Query

[adam_mc]

For a Dimensional Source Transformer Cube:

I have a burst query that returns e-mail addresses for Region and District Managers.

Region   R-Email                    District   D-Email
1            jsmith@xyz.com      10          jdoe@xyz.com
1            jsmith@xyz.com      11          aaa@xyz.com
1            jsmith@xyz.com      12          bbb@xyz.com
2            jjones@xyz.com      20          ccc@xyz.com
2            jjones@xyz.com      21          ddd@xyz.com


If I want to burst a District Level report to all District Managers this is straightforward.

However, I am having difficulty bursting a Region Level Summary report to all District Managers.
So jdoe@xyz.com, aaa@xyz.com, bbb@xyz.com, ccc@xyz.com, and ddd@xyz.com need to all receive the same report.

The e-mail addresses are within the cube source (Member Description) of the Store Hierarchy.

I would be grateful for any thoughts as to how this can be accomplished.
Thanks in advance,
Adam.

[adam_mc]

Was able to resolve on my own...

Created SQL with following statement (directly against Oracle DB not against cube)

select 'DM' as ALL_EMAILS,
   rtrim (xmlagg (xmlelement (e, a.email_address || ',')).extract ('//text()'), ',') as EMAIL_LIST
from
(select distinct (email_address) from [SITES]) a

Then use the results of this SQL as my burst query.

Thanks to anyone who began looking at this, I appreciate it!
Adam.