How to Convert a Text Date-time to a Numeric Element
Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For example, if you have an Excel file as the original source with a date time formatted from a date serial. In Excel the data displayed as, say, “2021-07-06 06:30” and is stored as 44383.2708333333. However, […]
Deriving an Element from an Alias in TM1
How do you derive an element ID from an alias or attribute in TM1?
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 […]
How to use a Dynamic Path in a TI for a Data Source
Using variables in a TM1 or Planning Analtyics Turbo Integrator process to dynamically vary the path for datasource for both server and client.
SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): How to 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 group of characters of a specified length from a larger string of characters. Syntax of SUBST The syntax is: where: string, is the text string that you want to take a slice […]
Scan TM1 Function: How to Use, Syntax and Examples
Scan is a TM1 function that finds the numeric position of the first instance of a specified substring within a string. If the substring is not found, it returns zero. It is essentially the same as the FIND command in Excel and CHARINDEX in SQL Server. Syntax of SCAN The syntax is: where substring is the substring you […]