HI
I have happily seen that Cognos now supports naming excel worksheets dynamicly.
This works as it should when I run a report manually.
But it does not seem to work when a report is scheduled to run automaticly and distributed via mail.
Does anyone know if this is a kown limitation or should we investigate why it does not work for us?
In the documentation:
"To dynamically name Excel worksheet tabs, ask your administrator to add the RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE advanced setting to the report service."
These links provide additional detail.
Dynamically named excel tabs is really a fantastic enhancement that people have been asking about for years!
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_setadvancedsettingsforadispatcherservice.html?lang=en
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/t_ug_cra_adv_prop_name_worksht_tabs_excel2007.html
Quote from: thomasbk on 25 Oct 2015 02:19:38 AM
HI
I have happily seen that Cognos now supports naming excel worksheets dynamicly.
This works as it should when I run a report manually.
But it does not seem to work when a report is scheduled to run automaticly and distributed via mail.
Does anyone know if this is a kown limitation or should we investigate why it does not work for us?
When you run a report interactively, it is rendered by the Report Service. If you have made the change noted above by Lynn to the Report Service, then reports run interactively will support dynamic worksheet names in Excel.
When you run a report in batch or via a schedule, it is rendered by the Batch Report Service rather than the Report Service. Unless you have made the same change to the Batch Report Service, you're not going to see dynamic worksheet names in Excel. If you make the same change to the Batch Report Service as you have already made to the Report Service, this should give you what you need.
Cheers!
MF.