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 […]
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 […]