COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: raj_aries81 on 26 Feb 2015 02:49:24 AM

Title: Appending MMMYYYY to the Email Attachment
Post by: raj_aries81 on 26 Feb 2015 02:49:24 AM
Hi All,

I have a scheduled report that runs every month and the report is sent to the via email. I want to append the MMMYYYY to the report output so that users are aware of the reporting month. When I googled, I came across the below link that has information about configuring few parameters by admins for achieving this.

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_asg_add_timestamp_toname.html

Please let me know if there a way that this can be accomplished from a Developer standpoint...Thank you.

Regards
Raj

Title: Re: Appending MMMYYYY to the Email Attachment
Post by: BigChris on 26 Feb 2015 04:05:36 AM
That post looks very much like an admin function...just depends what you're allowed to do on your system.
Title: Re: Appending MMMYYYY to the Email Attachment
Post by: Robl on 26 Feb 2015 06:45:38 AM
I looked into this a while back and my conclusion was that it's wasn't practically possible.
The best workaround I could find was to add a dummy email address for date@_._
It would cause lots of errors in the error log about emails not being sent, but it did mean you could see the content of the attachment before opening it.
Title: Re: Appending MMMYYYY to the Email Attachment
Post by: nsaxena on 26 Feb 2015 08:17:39 AM
Hi
I tried the steps given in below URL but it did not work.
I even re-started the cognos service,still getting the email report attachment (pdf file) without date

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_asg_add_timestamp_toname.html

Did anyone tried it recently ?
Title: Re: Appending MMMYYYY to the Email Attachment
Post by: raj_aries81 on 05 Mar 2015 01:49:12 AM
Quote from: raj_aries81 on 26 Feb 2015 02:49:24 AM
Hi All,

I have a scheduled report that runs every month and the report is sent to the via email. I want to append the MMMYYYY to the report output so that users are aware of the reporting month. When I googled, I came across the below link that has information about configuring few parameters by admins for achieving this.

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_asg_add_timestamp_toname.html

Please let me know if there a way that this can be accomplished from a Developer standpoint...Thank you.

Regards
Raj



Hi Nishant
I don't have admin privilages to try that, I will try check that on my local machine

Regards
Raj
Title: Re: Appending MMMYYYY to the Email Attachment
Post by: raj_aries81 on 05 Mar 2015 01:52:01 AM
Quote from: Robl on 26 Feb 2015 06:45:38 AM
I looked into this a while back and my conclusion was that it's wasn't practically possible.
The best workaround I could find was to add a dummy email address for date@_._
It would cause lots of errors in the error log about emails not being sent, but it did mean you could see the content of the attachment before opening it.

Hi Robl,

Could you please eloborate.Is that  through report bursting.

Regards
Raj
Title: Re: Appending MMMYYYY to the Email Attachment
Post by: Robl on 05 Mar 2015 02:43:57 AM
Yes.
In the burst recipients in the report you just need to fabricate a new email address based on the current date.

So if the recipient list was 'dave@dave.com; barry@barry.com' you just make it look like 'dave@dave.com; barry@barry.com; March_2015@_._'