TM1 Forum

Posted: **Thu Jan 27, 2011 12:44 pm**

Hi

I am using "asciioutput" to output to a file the values calculated in a TI process

It errors when I try to output a numeric value.

my code...

Code: Select all

temp =  CellGetN('atm test','Volume', abank, ateamno, acentre, teamtype, 'Totkm', aregion, adate);

asciioutput ('aa.txt',astats,aregion,ateamno,adate,aservtype, temp);

The asciioutput errors as soos as I add the 'temp' keyword. "temp" was defined in the "Variables" tab, as Numeric.
How do I convert ths numeric value to string to be seen in the output file? Or is there any other way I can "trap" values for debugging?

Thanx!

Posted: **Thu Jan 27, 2011 1:08 pm**

Look in the IBM Cognos TM1 Reference Guide, paying particular attention to the section Rules Functions, Text Rules Functions.

Posted: **Thu Jan 27, 2011 2:26 pm**

Code: Select all

asciioutput ('aa.txt',astats,aregion,ateamno,adate,aservtype, NumberToString (temp));

Posted: **Thu Jan 27, 2011 5:14 pm**

Thankyou guys

I'm a newbie

Posted: **Thu Jan 27, 2011 5:19 pm**

don't worry, that one has caught all of us at one time or another

TM1 Forum

asciioutput

asciioutput

Re: asciioutput

Re: asciioutput

Re: asciioutput

Re: asciioutput