TM1 process error :Cannot convert field 8

[himanshurai420]

Hi all,

I am new to TM1 and trying to create a TM1 process to write data into .csv file from a cube view and for the same i m using asciioutput function.
Below is the function and the error message.

Code: Select all

asciioutput('file.csv
',version
,category
,detail
,unit
,component
,numlist
,period
,numbertostring(value));

Error message:-

Data source line (1) error: data procedure line(0):cannot convert field number 8,value held for approval to a real number.

the above mentioned error is coming for all the records,

Could anyone of u please help me out.

thanks in advance....

[Wim Gielis]

Hello

Did you check the variable type (numeric or string) for your 8th variable?

Please also note that AsciiOutput requires every argument to be a String (text instead of numeric).

Wim

[himanshurai420]

Thanks Wim,

The variable type is string for field number 8.

thanks one again for ur information about Asciioutput function.

[Wim Gielis]

Please provide screenshots of the variable Preview, the variables tab, the code and the error message.

[himanshurai420]

Sorry wim,

not able to provide the screenshot and the variable type is number of the field 8.

thanks...

[Wim Gielis]

Then set the variable type to String and if needed, use functions like StringToNumber, StringToNumberEx or Numbr to convert text to a number.
See: http://users.skynet.be/fa436118/wim/tm1 ... ngs_EN.htm

[himanshurai420]

Thanks a lot Wim.....It worked

[Wim Gielis]

You're welcome !