TI Functions

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

DimensionElementComponentAddDirect TM1 Function: How to Use, Examples and Syntax

Posted on Jul 5, 2023 by John

DimensionElementComponentAddDirect adds an existing element in a TM1 dimension into a hierarchy as a child of another element immediately.  In other words, it is used to create rollups as the command…

TM1 RoundUp Function: Method, Syntax and Use

Posted on Mar 7, 2022 by Andrew Walker

The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple method to achieve exactly the same outcome. TM1 RoundUp Method The method…

INT in TM1: Finding the Largest Integer Less Than or Equal To a Specified Value

Posted on Mar 7, 2022 by John

The INT function allows you to return the nearest integer less than or equal to a specified value. Syntax of INT The syntax of the INT function is simply: INT…

How to find the Largest of Two Values in TM1: MAX Function: Syntax and Use

Posted on Mar 7, 2022 by John

The Max function will deliver to you the largest of two numbers. For example, if you have 50 and 100, using the MAX function will return 100. Syntax of MAX…

ELWEIGHT TM1 Function: How to Use, Syntax & Example

Posted on Nov 16, 2021 by John

Ever wondered how you can use the weight assigned to an element in a hierarchy in a rule or turbo integrator process? Well, ELWEIGHT allows you to do just that!…

DAY TM1 Function: How to Use, Syntax and Example

Posted on Sep 13, 2021 by John

The DAY function in TM1 is almost exactly the same as the DAY function in Excel, in that it returns the day of the month from a date. It is…

DimensionDestroy: How to Delete a Dimension in TM1

Posted on Sep 3, 2021 by John

Sometimes we want to just delete a dimension from TM1. We get lots of failed searches on our site for DimensionDelete – but unfortunately that doesn’t exist. IBM, in their…

How to Delete All Elements from a TM1 Dimension: DimensionDeleteAllElements

Posted on Jul 2, 2021 by John

Have you ever needed to just delete all elements from a dimension in TM1? Well there is a super easy function that does just this. Using DimensionDeleteAllElements, then one click…

Sleep in TM1: How to Pause a TI Process

Posted on May 8, 2021 by John

Have you ever need to make a Turbo Integrator process sleep for a short while so another system can catch up? Getting a TI to pause can be a really…

ELCOMP TM1 Function: How to Use and Syntax

Posted on Apr 22, 2021 by John

The ELCOMP function in TM1 is used to derive the element at a specific position as the child of a parent. Syntax The syntax is: ELCOMP(DimName, Parent, Position) where: DimName…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles

Keen to chat? Book a discovery call!

pen