Category Archives: Turbo Integrator

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.

This entry was posted in Rule Functions, TI Functions and tagged Date, Dates, Month. Bookmark the permalink. | Tagged Date, Dates, Month | Leave a comment

Checking if an Attribute Exists (essentially an “AttributeExists” Function)

Here is a really easy method for checking if an Attribute Exists in TM1 via Turbo Integrator process. It essentially does what an “AttributeExists” or an “AttrExists” function would do for you if they existed in TM1.

This entry was posted in TI Coding, TI Functions and tagged AttributeExists, AttrInsert, DimensionCreate, DimensionExists, dimix. Bookmark the permalink. | Tagged AttributeExists, AttrInsert, DimensionCreate, DimensionExists, dimix | Leave a comment

Date Function in TM1: Syntax and Use

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

This entry was posted in Rule Functions, TI Functions and tagged Date. Bookmark the permalink. | Tagged Date | Leave a comment

Date and Time Functions in TM1 10.2

Manipulating dates and times in TM1 has always been horrible. Here we discuss the time manipulation methods available from TM1 v10.2 onwards. These include NewDateFormatter, FormatDate and ParseDate. With them you can even change time from one time zone to another.

This entry was posted in TI Functions, TM1 10.2 and tagged FormatDate, NewDateFormatter, ParseDate, Time, Turbo Integrator. Bookmark the permalink. | Tagged FormatDate, NewDateFormatter, ParseDate, Time, Turbo Integrator | Leave a comment

Using the DimensionCreate Function to Create a Dimension in TM1

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

Checking if a DimensionExists in a TM1 Model

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

“Joining” Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

This entry was posted in Attributes, Data Connection, TI Data Sources, TI Processes and tagged Attribute, Dimension, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Attribute, Dimension, TI Process, Turbo Integrator | Leave a comment

Data Export Tool Review – Flyspeed

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged ETL, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged ETL, TI Process, Turbo Integrator, TurboIntegrator | Leave a comment

How to Create a Secure Gateway for Planning Analytics

There are a couple of elements that must be established to make the secure gateway work. There are server side and local side requirements. This post deals with what has to be done on the IBM server so you can connect it to your local data. For instructions on establishing the local side of the connection, please see this post. Server Side Configuration In the Welcome Kit from IBM, there is a … Continue Reading

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged data connectivity, secure gateway. Bookmark the permalink. | Tagged data connectivity, secure gateway | Leave a comment

AsciiOutput with Pipe Delimiter

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect directly and publish from TM1 to SQL Server, but I just wanted to use the simple method – create a text file and load it up. Problem with Comma Separated Values My problem was that some of the columns contained text that had random commas, so a regular AsciiOutput wouldn’t work … Continue Reading

This entry was posted in TI Coding and tagged ASCIIOUTPUT, delimiter, SQL Server. Bookmark the permalink. | Tagged ASCIIOUTPUT, delimiter, SQL Server | Leave a comment