DayNo TM1 Function: Use and Syntax - Yesterday I was doing some work on an inventory forecasting system.  I had Year, Month and Day dimensions and needed to bring through ... - is.gd/mldkCj - #RuleFunctions #TIFunctions

IF() TM1 Rule Function: Use and Syntax - IF() is a function that can be used to test if an expression is true so that you can then differentially execute a rule based on the o... - is.gd/Ox65I3 - #RuleFunctions

RIGHT TM1 Function: Use and Syntax - The RIGHT function from Excel does not exist in TM1. We need to use a combination of SUBST and LONG functions instead. Where you have a ... - is.gd/CxUdY2 - #RuleFunctions #TIFunctions

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 ... - is.gd/QmaVCh - #RuleFunctions #TIFunctions

LEFT TM1 Function: Use and Syntax - The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you have a formula in Excel in A2 that is = LEFT... - is.gd/mroVhz - #RuleFunctions #TIFunctions

ATTRN TM1 Function: Use and Syntax within TI and Rules - ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element in a dimension in ... - is.gd/jjFlSR - #Attributes #RuleFunctions #TIFunctions

DimSiz TM1 Function: Use and Syntax - The TM1 function DimSiz returns the total number of #Elements in a TM1 dimension. Syntax of DimSiz The syntax is DIMSIZ(dimension); ... - is.gd/eGpXUs - #RuleFunctions #TIFunctions

ELLEV TM1 Function: Use and Syntax - The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax The syntax is ELLEV(dimension, ... - is.gd/QTW6DA - #Elements #RuleFunctions #TIFunctions #TIProcesses

SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax - The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that it allows you to select a... - is.gd/6RXa2A - #RuleFunctions #TIFunctions

DIMNM TM1 Function: Use and Syntax - The TM1 function DIMNM returns the name of an element from its index in a TM1 dimension. Each element in a TM1 dimension has an index ... - is.gd/uxmA0p - #Elements #RuleFunctions #TIFunctions

DimSiz TM1 Function: Use and Syntax - The TM1 function DimSiz returns the total number of #Elements in a TM1 dimension. Syntax of DimSiz The syntax is DIMSIZ(dimension); ... - is.gd/KHi2rK - #RuleFunctions #TIFunctions

Scan TM1 Function: Syntax and Use - Scan is a TM1 function that find the numeric position of the first instance of a specified substring within a string. If the substring... - is.gd/TnikH7 - #RuleFunctions #TIFunctions

Using STET and CONTINUE in TM1 Rules - Using STET and CONTINUE in TM1 rules to indicate if the rule sheet should continue to execute for the current intersection. This is... - is.gd/xjksHV - #RuleFunctions

Now() TM1 Function: Syntax and Use - The Now function returns the current date-time stamp from the TM1 server Syntax of Now The syntax is Now();  There are no a... - is.gd/wJ42fz - #RuleFunctions #TIFunctions

DIMIX TM1 Function: Use and Syntax - DIMIX Function: Explanation and Use in Turbo Integrator Processes and Rules in TM1 and Planning Analytics to assess if a variable exists... - is.gd/09JrKz - #RuleFunctions #TIFunctions

Scan TM1 Function: Syntax and Use - Scan is a TM1 function that find the numeric position of the first instance of a specified substring within a string. If the substring... - is.gd/EISB3y - #RuleFunctions #TIFunctions

Using STET and CONTINUE in TM1 Rules - Using STET and CONTINUE in TM1 rules to indicate if the rule sheet should continue to execute for the current intersection. This is... - is.gd/qYJnXw - #RuleFunctions

SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax - The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that it allows you to select a... - is.gd/sguc8A - #RuleFunctions #TIFunctions

Scan TM1 Function: Syntax and Use - Scan is a TM1 function that find the numeric position of the first instance of a specified substring within a string. If the substring... - is.gd/xa8uSP - #RuleFunctions #TIFunctions

Using STET and CONTINUE in TM1 Rules - Using STET and CONTINUE in TM1 rules to indicate if the rule sheet should continue to execute for the current intersection. This is... - is.gd/SFEckT - #RuleFunctions