StringToNumber TM1 Process: Use and Syntax
StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.
How to Pad a Variable Length Element in TM1
Often we have a situation were we want to create a dimension with the contents of a code from a source system. Sometimes, however the IDs in the source system are of a variable length and we want to present them uniformly. To overcome this, we need to pad the code at the left with a […]
NumberToString TM1 Function: How to Use and Syntax
NumberToString Function for use in Turbo Integrator processes in TM1 and Planning Analytics to convert numbers to text (or strings). From here you can use it with other strings or output to a text file.
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 […]