CM.OUTPUTLOCATION option: Excel reports have do not have an XLS extension?

Cognos 8 Business Intelligence Installation and Configuration
1

Hi,

iā€™m using cognos 8.4 and when i use the CM.OUTPUTLOCATION directive, Excel files are exported as .MHT files (the RSVP.FILE.EXTENSION.XLS directive doesnā€™t work),

Is there a method was to automatically rename the files to .XLS or solve this another way?

I use windows 2003 and office Excel 2007.

help?

2

RSVP.FILE.EXTENSION.XLS property works just fine for me with same config as yours: Windows 2003 and Excel 2007. Iā€™m on 8.4. Also, I have 6 dispatchers and what I noticed, when you have multi-server environment, you better use System under Status tab (right lower corner, Setting - System) and NOT Configuration tab and then Dispatchers and Services as it described in this IBM KB, which Iā€™m assuming you aware of: http://www-01.ibm.com/support/docview.wss?uid=swg21342065&loc=en_US&cs=utf-8&lang=en. Again, that is my own observation, but hope that help you to accomplish your configuration. Good luck with it!

Alex

3

I found this in my documents on my pc:

Using the following in a CM.OutputScript will automatically rename each .MHT file to .XLS as it is produced.

@echo off
cd x:\{report_location}
ren x:\{report_location}\*.mht *.xls

Steps:
Create a batch file containing with the above code.
Add the CM.OutputScript directive, pointing to the path containing the script, into the ā€˜Advanced Settingsā€™ for the Content Manager service.

More detailed instructions for setting the CM.OutputScript parameter can be found in the ā€œAdministration and Security Guideā€ (ug_cra.pdf) shipped with the product, in the chapter entitled ā€œServer Administrationā€