Skip navigation.
spilling the beans


| |

AsciiOutput can help tracking what values are being used during execution of your TI processes.


Keep in mind Asciioutput limitations:
. it is limited to 1024 characters per line
. it can deal only with strings, so you need to apply the NumberToString() function to all numeric variables that you would like to display like var3 in the example above.
. it will open/close the file at every step of the TI. Prolog/Metadata/Data/Epilog that means if you use the same filename to dump your variables in any of these, it will be overwritten by the previous tab process.
Hence you should use different filenames in each tab.
. use DataSourceASCIIQuoteCharacter=''; in prolog if you want to get rid of the quotes in output.
. use DatasourceASCIIThousandSeparator=''; to remove thousand separators.

Alternatively you can use ItemReject if the record you step through is rejected, it will then be dumped to the error message

Average rating
(1 vote)

Separator characters in asciioutput file

Thanks for the summary of the ASCIIOutput function. We are using TM1 9.4.1 and in the middle of a big ERP implementation. The SI team have requested that output files from TM1 (budgets and forecasts) be provided in .txt file with values (strings) separated by | (pipe) symbols and not commas. I have looked through all the documentation and the posts on this site, but can't find out whether anything other than , (commas) can be used to separate output variables. I'd be grateful to know whether it is possible to use 'pipes' (apart from editing and replacing the output file after it has been generated).

Thanks in advance!

you must use the function

you must use the function DatasourceASCIIDelimiter