Strings: All You Can Eat!

All about strings. Whether you’re a cat chasing a ball of string, or a TM1 admin manipulating strings to push them out to an ASCII file, concatenating them, or sending them to a text-based attribute, here is your complete guide to all things to do with strings in TM1.

TI Functions | Turbo Integrator

StringToNumber TM1 Process: Use and Syntax

StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator...

Rule Functions | Rules | TI Functions | Turbo Integrator

DType Function in TM1: Syntax and Use

Use, syntax and example of the DType function in TM1 and Planning Analytics. In this post we...

Pipe Delimiter

Integration | TI Best Practices

AsciiOutput with Pipe Delimiter

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect...

Rule Functions | Rules | TI Functions | Turbo Integrator

Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is...

Rule Functions | Rules | TI Functions | Turbo Integrator

STR TM1 Function: Syntax and Use

STR is a TM1 function that converts a number to string. It is very similar to the Excel function...

Rule Functions | Rules | TI Functions | Turbo Integrator

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!...

LONG TM1

Rule Functions | TI Functions

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...

Rule Functions | Rules | TI Functions | Turbo Integrator

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...

Administration | Integration | TI Functions | Turbo Integrator

Text File Export from TM1 – AsciiOutput Functions

When we are exporting from TM1 to a text file there is a set of functions we can set that modify...

CellGetS TM1

CellGetS TM1 Function: How to Use and Syntax

CellGetS allows you to retrieve a string (text value) from a specific intersection in a TM1 cube...

Header Row from AsciiOutput

Administration | Integration | TI Best Practices | TI Data Sources | TI Functions | Turbo Integrator

How to Create a Header Row with AsciiOutput

Here is a great explanation of how to add a row of column headings to an AsciiOutput from...

Rule Functions | Rules | TI Functions | Turbo Integrator

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...

SCAN, TM1's FIND function

Rule Functions | Rules | TI Functions | Turbo Integrator

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...

TI Functions | Turbo Integrator

NumberToString TM1 Function: How to Use and Syntax

NumberToString Function for use in Turbo Integrator processes in TM1 and Planning Analytics to...

Attributes String

Attributes | Dimensions | Rule Functions | Rules | TI Functions | Turbo Integrator

ATTRS TM1 Function: How to Use and Syntax within TI and Rules

ATTRS Function for use in Rules and Turbo Integrator Processes in TM1 and Planning Analytics to...

Fixed Width File Format from TM1

When outputting data from TM1 usually we can get away with comma separated values format. Which...

Administration | Integration

Guest Post: Sorting TM1 Text Output – Wim Gielis

First of all, thanks to Ben for inviting me to write this guest article. The case is as follows....