Burst report and send per mail with dynamic subject

[djknuddel]

Hi there,

I have a report that is bursted and sent per mail to different recipients. That is working fine.

At the moment the subject in every email is the same and the name of the pdf file I sent in these mails is always the same too. Thats annoying because if one person gets 2 or more mails then all mails look the same.

Is there a possibility to get the burst key into the subject and into the file names? Thats only logic for me and I wonder why Cognos doesn't have such an option yet.

Any help would be appreciated.

[dew]

Hi.

I also have a user that have requested this.

I'm developing a SDK program to do this for me.
I have managed to get the info i need inside the subject to be dynamically included in the burstkey.
This can then be extracted and put inside the email subject.
My problem now is, once i have saved the port outputs to the content store, how do i email them?  I will need to locate each report output object and then email it.  I found that the email method only works with report objects, not report outputs.

If someone knows how to email specific report outputs please post it and make my day.
Once i figured out how to do it, i will try and post it here.

Regards,
Dew

[agm]

I don't know about the file names, but I think that if you set up an Event, you'll be able to customize the subject.

[Sune Jorgensen]

In Event Studio it is not possible to include data values in subject or body. It look like it is possible, but the field name is only showed with brackets and not the value.

It is only in the email options it is possible, but then you can not attach a report.

[dew]

Hi guys.

Here is what i manage to do to get the subject cusomized:

In the report, I added a data item to one of my queries (the same query that contains the main page fields ).
In this query item, i concatenated all the values that i want in the subject.

Then I set the burstkey equal to this new query item in the File > Burst Options window.  (Note this was added to the query and not to the list itself, so that the field does not show up in the report in the end)

After I run(and save) the report - I have a list of bursted outputs, each with its own customized burstkey.

Then I use the SDK to do the following:
- Run the report to make sure I have atleast one report version.
- Query the Content Store to get the latest report version, and get a list of bursted outputs for that version.
- Download each output together with its burstkey.
- Now I have all that i need - I can now change the email subject, or filename of the report, to whatever i want.
- Last step is to create a email with customized subject and attach the relevant output file (pdf in this case) to it 

I used JAVA for the SDK stuff above.

I still wonder why this is not a standard functionality within Cognos 

Hope this helps

Regards,

[vamu]

Hi,

Can you explain the SDK and can post your SDK???

Thanks in adavance!!!

Vamu

[kslanicky]

Sune - but in the email option you can add a link to a report.  So the report could be run separately, and then the event runs and send an email with the dynamic subject line, with the report linked in there.  Just an idea/option