Hi All,
I'm on 9.0 sp3 and have an Asciiout put TI process where some of the data ia exporting as scientific formatting. Our SQL consultant cannot automate the data with these sceintific formats, and there seems to no consistancy to the general vs. scientific format on the .csv extract.
Does anyone know how to ensure the format of the extract will be general?
ASCIIOutput('\\tltm1pm1\tm1_ODBC_Data\FMR\FinPlan.csv', Vyear, actvsbud, channels, PRODUCT, INSTYPE, INCSTAT, MONTH1, Data);
asciioutput formatted as scientif...
-
- Posts: 31
- Joined: Tue Jun 10, 2008 8:21 pm
- OLAP Product: TM1
- Version: 9.1sp4 64x
- Excel Version: 2003
- Location: Hartford, CT
Re: asciioutput formatted as scientif...
I'm all set after adding a numbertostring function in the formula:-)