RIGHT TM1 Function: Use and Syntax
If you are looking for the RIGHT function in TM1, you’ll find that it doesn’t actually exist! Instead it is a combination of SUBST and LONG functions. This post give’s a step-by-step explanation into how to achieve the same result in TM1.
LONG TM1 Function: Syntax and Use
The LONG function in TM1 returns the length of a string as a value. It is similar to the LEN functions available in both Excel and SQL Server. Syntax of LONG The syntax is: where string is either the literal string to be evaluated or a variable that contains the string to be evaluated. Use An example of […]
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 […]