TI Best Practices

TI Best Practices

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…

TI Best Practices, TI Data Sources, TM1 Performance

What’s the Fastest Method to Copy Data from Cube to Cube?

What is the fastest way to get data from one cube to another via a TI – is it use a view of the source and the CellPut functions to load it or is it faster to Extract and Load?

TI Best Practices

How to Unwind a Dimension in TM1

This is a case study of how to unwind a dimension without deleting all the elements. Includes simple TI code that you can use.

TI Best Practices, TI Functions

Selective Clear Cube based on Variable Source Data

Detailed instructions on how to clear a variable selection of data that is going to be reloaded from the source. Includes sample TI code and explanations.

Security, TI Best Practices, TM1 Management, Turbo Integrator

Element Level Security – Cascading through a Dimension in TM1

Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.

TI Best Practices, TI Functions

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.

TI Best Practices, TI Functions

Date and Time Functions for Easy Date Manipulation

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.

Integration, TI Best Practices