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.
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.