I found a document on changing the CSV delimiter on IBM's website
https://www-304.ibm.com/support/docview.wss?uid=swg21338932 (https://www-304.ibm.com/support/docview.wss?uid=swg21338932)
However I am using 8.4.1 and can't quite figure out what I need to do. It says in the portal go to Tools-Server Administration. Anyone know what they are talking about? I know this is something simple I'm overlooking but I just can't find where to start looking to change this environment variable.
In 8.4.x you would follow the steps as below
1. Select "Launch"
2. Select "Cognos administrator console"
3. Press the "System" link on the left hand side under the "Status" tab
4. Press the blue down arrow next to System in the scorecard pane
*NOTE: There will be a dropdown selection and you will need to select "Set Properties"
5. Select "Set Properties" from the drop down selection
6. Select the Settings tab
7. Click on "Edit" on the advanced settings option
At this point you should see two columns for parameters and values. Its here that you need to add the environment variables.
*NOTE: You will likely need to restart the c8 services.
Another good reference for advanced settings is
http://it.toolbox.com/wiki/index.php/Cognos_Advanced_Settings
Hope this helps
Cheers
Peter B
Pete I did what you said and it works great.
I have another question. Is it possible to set the delimiter to be different for a specific report? I have multiple CSV's that I need to run and most are in | delimited format but I have a single file that I need in , delimited format and besides manually editing the file I have not found a way to do it.
Basically is it possible to have 2 different delimiters active on a single Cognos server at a given time?