2017-02-28 03:31 AM - edited 2017-02-28 03:35 AM
There is a requirement to prefix or suffix date stamp on the attached report name. I know we can do that within report, but can't think of a way to use that function outside report studio.
The report is developed and scheduled.
For eg report name is "Storage Utilization", but when user receive that in his/her inbox then he/she see the attachment as "Storage Utilization 2017-02-28". And when same report run on 1st March then it should be "Storage Utilization 2017-03-01"
Note: I need that on attached report, not in subject line of mail
2017-02-28 09:18 AM
I haven't tried it myself, but the IBM document linked below seems to provide instructions on how to do this.
Note that after any OCI upgrade, you will need to re-implement the change to Advanced Settings. These settings are not preserved through OCI upgrades.
2017-03-03 06:42 AM
I creating followed the steps mentioned in that link. Created optional paramter too to specify the format, but still next day schedule reports don't have date stamp.
Link just mentioned about creating new parameter but how it is applicable to attachments? We have not specified any variable anywhere in report name.
And where? I mean it suffix date stamp or preffix.
Would you please test it yourself and see if that is really working?
2017-03-05 02:43 PM
I don't have SMTP rigged up in any of my labs, and it may not be practical to do so.
One thing I should have recommended you check, is whether the procedure in the IBM article applies to the version of Cognos running in your version of OCI. It's possible this is a too-new option.
2017-03-31 03:13 AM
After I upgraded OCI to 7.2.4, my cognos is on same version as mentioned in the link I posted earlier. Still that is not working.
Can someone else try the same who have SMTP configured in their environment? or suggest alternative way to achieve this.