Output file name while scheduling a report using Cognos 8.0 scheduler 1

[spattewar]

Hi,

Thanks for your time.

In my scenario I have to schedule 5 reports that I have created using the Report Studio in Cognos 8.0. While configuring the schedule there is no place to enter the output file name. Because of this each time when the scheduled report runs it creates a dynamic output file name. I have other internal systems that are using this output and am finding it difficult for them to pick up the files in this case.

I am saving the report outputs in csv format.

Can anyone let me know how to set the output file name for the report in the Cognos 8.0 scheduler. Also if it not straight forward, is there a workaround for this.

Thanks all for your inputs.

Regards.
Swapnil

 

[YamaCog56]

Perhaps this tidbit from the Cognos KB will help:

You can save PDF report outputs to a file system location. When you run a report and specify the run option to save the report output, the output is saved on the server. You can also save a copy of the output in a location you specify.

You can specify a script to provide an open interface so that you can run any post-processing commands you want each time a report output is copied to the file system. For example, if your report outputs will ultimately be stored in an archiving system, you can use a script to perform this action.

Before you can save reports to a file system, you must have execute permissions for the Administration secured function. For more information, see Securing Functions and Features.

Steps:

1. In Cognos Connection, click the Server Administration link.

2. In the Server Administration page, under Type, click the Services radio button and then choose Content Manager in the drop-down menu.

The Content Manager service appears below the drop-down menu.

3. Under the Actions column, click the set properties button.

4. Click the Settings tab.

5. Under the Value column, click Edit.

6. In the Set advanced settings - ContentManagerService page, select the Override the settings acquired from the parent entry check box.

A table appears, in which you can add parameters.

7. Under Parameter, click in a cell and type

CM.OUTPUTLOCATION

In the corresponding Value cell, type the file system location where you want to store report outputs.

for example

c:\reportoutput

Also note this will not work if you specify a UNC name.

If you want to specify a shell script, such as a .bat or .sh file, that will run after a report output is saved to the target directory, do the following:

Under Parameter , click in an empty cell and type

CM.OUTPUTSCRIPT

In the corresponding Value cell, type the location and the name of the script.

The full file names of the output file and descriptor are passed to the script. For example, c:\reportnet\146_1062107695000.pdf c:\reportnet\146_1062107695000_desc.xml.

8. Click OK.

Copies of saved report outputs are placed in the location specified. Old report versions are not deleted when a new one is saved. You must manage the content of the output directory to keep the report versions you want.

9. For Cognos 8 MR2, following steps are also required:

a. On the computer where you installed Content Manager, start Cognos Configuration.

b. In the Explorer window, under Data Access, click Content Manager.

c. In the Save report outputs to a file system box, click True or False.

d. From the File menu, click Save.

e. Restart the Cognos 8 service.

 

[spattewar]

YamaCog56, first let me thank you for providing your input and time on this. I haven't tried it and I am trying it now.

Thanks again.