Monday, September 22, 2008

Cognos 8.3 - Steps for Comma delimited file addition into Cognos Environment

The default format of the CSV is tab delimited.

The steps involved in adding it to the Cognos Connection is as follows:

1. Go to Cognos Connection.
2. In the upper-right corner, click Launch, 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.
ie.
RSVP.CSV.DELIMITER: ,
RSVP.CSV.ENCODING: windows-1252
8. Click OK.

Note:
It takes about 30 seconds after this change for the changes to take effect.
COOL!!! Right 

No comments: