change scheduled report email subject dynamically

[ub14]

Hi,

We have requirement to display  monthly schedule report email subject dynamically based on the month like " Monthly Status Report - November 2011'.  Do we have any option to do this in event Studio or using Cognos SDK.

Thanks in Advance.
vsub

[rubanlawrence]

Hello vsub,

Currently, there isn't an easy way to do this directly within the product. There is an enhancement request open at IBM Cognos to get this functionality put into the product, however.

One approach that comes to mind is this:
1. Setup your C8/C10 to output scheduled reports to the filesystem.
2. Build an external application to parse the XML files that accompany the output files and then have your external application e-mail the output with the dynamic subject line you'd like to have.

With this possible solution, Cognos' work stops at generating the output - and the application you'd build would do the rest (so completely outside of Cognos.)

Good luck!  :)

[kslanicky]

You could POTENTIALLY use Event Studio... because with Event STudio, you can insert a dynamic subject in an email.  You would then also add a link to the report in the email.

The problem is going to be how you manage the event list... and how you tell the Event to use/show the correct month in the subject.

Should be feasible with calcluations, either in Event Studio or in FM... but it would certainly be unconventional.

Good luck!