Not sure which forum to post this.
Business Challenge: E-mail variations of an Excel report to different users.
Ideally, I'd like to set up a table in the source database that has a column for the parameter value and corresponding e-mail address, then have Cognos push the reports to the specified e-mail address with the specified parameters once a week.
Is this possible, and if so, what is the best way? There would be over 100 parameter values/e-mail address to maintain, so being able to maintain a table of values would be a lot better (and have better business/audit controls) than manually creating, scheduling, and editing jobs.
This is a similar question with a response that might be useful.
http://www.cognoise.com/index.php/topic,26147.msg83100.html#msg83100
I looked into bursting, but the report is complex with crosstabs, which don't appear to work with bursting.