COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: prikala on 04 Dec 2013 04:02:08 AM

Title: cogtr.xml Options DumpCSVEnabled and DumpCSVPATH
Post by: prikala on 04 Dec 2013 04:02:08 AM
I have a need to dump into a csv file the fact data used to create a certain cube.
Options DumpCSVEnabled and DumpCSVPATH seem almost perfect for the job but they don't seem to be documented.

Does anyone know anything about these options? Can I control the format of the csv in any way?

The reason I am asking is that when I dump a certain package based data source, number value "-0.2" gets dumped into csv as "0.-2" which is not nice when I later try to use csv as input.
Title: Re: cogtr.xml Options DumpCSVEnabled and DumpCSVPATH
Post by: nybble on 11 Dec 2013 11:36:20 AM
Those store the preference values you can set in the UI.
In the Preferences dialog, go to the CSV Output tab and specify a folder.