If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Changing CSV delimiter

Started by Yunus, 24 May 2011 07:32:00 AM

Previous topic - Next topic

Yunus

I found a document on changing the CSV delimiter on IBM's website
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.

AussiePete2011

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

Yunus

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?