How to Dynamically Assign Information based on Data Entry
How to create a planning model where users can enter or select variables in one location and TM1 then assigns the data dynamically to all required dimensions. For example, in a budgeting model to plan labour centrally and assign people to cost centres dynamically.
YEAR Function in TM1: Syntax and Use
The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.
MONTH Function in TM1: Syntax and Use
The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here we explain it’s syntax and give an example combining it with the DATE function.
How to Convert a Numeric Date to a String using the DATE Function in TM1
The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 , 1); will return the string ‘1998-03-09’.