Producing a Report in CSV Format

IBM® Cognos® Business Intelligence can produce reports in CSV format so you can open them in other applications, such as Microsoft Excel spreadsheet software. Reports saved in CSV format

are designed to support Unicode data across many client operating systems
are UTF-16 Little Endian data encoded
include a BOM (Byte Order Mark) at the beginning of the file
are tab-delimited
do not enclose strings in quotation marks
use a new line character to delimit rows

You can open reports saved in CSV format using Microsoft Excel, Microsoft Windows Wordpad, and Oracle StarOffice software. By default, reports produced in CSV format will appear in the application associated with the .csv file type.

In IBM Cognos Connection, you can configure the CSV output to suit your environment. For example, you can specify the character used to delimit fields. For more information, see the Administration and Security Guide, or contact your administrator.