Tag Archives: TEXTOUTPUT

Fixed Width File Format from TM1

When outputting data from TM1 usually we can get away with comma separated values format. Which is standard functionality from a Turbo Integrator process [See ASCIIOutput, TextOutput functions]. Every now and then we need to interface with a ERP system which requires Fixes Width Fields. This presents a few problems, not insurmountable but still not expressly easy either. The tips below will make things easier for you. ASCII Quote Character Options To start your extract process … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator. Bookmark the permalink. | Tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator | Leave a comment

Guest Post: Sorting TM1 Text Output – Wim Gielis

First of all, thanks to Ben for inviting me to write this guest article. The case is as follows. Recently, the customer wanted an export from a cube view showing monthly revenue values per project. The user should open the exported file in Excel, modify and import back into TM1. Exporting data to a text file format like .CSV or .TXT is not an issue; an ASCIIOUTPUT() or TEXTOUTPUT() function … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Aexis, ASCIIOUTPUT, DataSourceAsciiQuoteCharacter, IBM Cognos TM1, Sorting Data, TEXTOUTPUT, TI Process, Turbo Integrator, Wim Gielis. Bookmark the permalink. | Tagged Aexis, ASCIIOUTPUT, DataSourceAsciiQuoteCharacter, IBM Cognos TM1, Sorting Data, TEXTOUTPUT, TI Process, Turbo Integrator, Wim Gielis | 6 Comments