asciioutput

Post Reply
Lorna
Posts: 15
Joined: Wed Jan 26, 2011 5:25 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

asciioutput

Post by Lorna »

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!
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: asciioutput

Post by tomok »

Look in the IBM Cognos TM1 Reference Guide, paying particular attention to the section Rules Functions, Text Rules Functions.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: asciioutput

Post by sachin »

Code: Select all

asciioutput ('aa.txt',astats,aregion,ateamno,adate,aservtype, NumberToString (temp));
Check out my blog for some good information on TM1, SPSS
Lorna
Posts: 15
Joined: Wed Jan 26, 2011 5:25 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: asciioutput

Post by Lorna »

Thankyou guys

I'm a newbie :P
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: asciioutput

Post by Steve Vincent »

don't worry, that one has caught all of us at one time or another :lol:
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Post Reply