Monday, 31 October 2011

Cognos 10.1.1 display EXCEL 2003 instead of CSV format

CSV output not coming

Check IBM Administrator guide under customisation for below steps and detailed list of variables
you can set



1.Start IBM® Cognos® Connection.

2.In the upper-right corner, click Launch, IBM Cognos Administration.

3.On the Status tab, click System.

4.From the System drop-down menu, click Set properties.

5.Click the Settings tab.

6.Next to Environment, Advanced Settings, click Edit.

7.Enter parameters and values from CSV Properties and Values, as required.

2.Click OK.


RSVP.CSV.DELIMITER - The field delimiter character used for CSV output.

Enter one of the following:

•a single character

If you enter more than one character, only the first character is used.


•TAB (tab)

This is the default value.


RSVP.CSV.QUALIFIER

The string qualifier used for CSV output.

The default value is " (quotation mark).

Enter a single character. If you enter more than one character, only the first character is used.

If the qualifier appears as part of your data, it is duplicated. For example, if the qualifier is a quotation mark and your data is ab"cd, the CSV output is "ab""cd".

1 comment:

  1. Hi Amenah,

    If you found this helpful.Please mark answer as helpful .Thank you

    ReplyDelete