Search
Search

TI Functions

TI Functions

DimensionElementComponentAddDirect TM1 Function: How to Use, Examples and Syntax

DimensionElementComponentAddDirect Function for use in TI Processes in TM1 and Planning Analytics to IMMEDIATELY consolidate (or rollup) elements in a dimension. Explanation with an example of use.

Rule Functions

TM1 RoundUp Function: Method, Syntax and Use

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

Rule Functions

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

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: where:

Rule Functions

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

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

Rule Functions

ELWEIGHT TM1 Function: How to Use, Syntax & Example

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!

Rule Functions

DAY TM1 Function: How to Use, Syntax and Example

The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY (’24-09-18′) will return the number 18.

Dimensions

DimensionDestroy: How to Delete a Dimension in TM1

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

TI Functions

How to Delete All Elements from a TM1 Dimension: DimensionDeleteAllElements

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

TI Functions

Sleep in TM1: How to Pause a TI Process

Full explanation of the Sleep function in TM1, with syntax and example so you can pause your Turbo Integrator process.

Rule Functions

ELCOMP TM1 Function: How to Use and Syntax

In TM1, ELCOMP returns the child element at a specified numeric position of a parent. Full syntax and explanation for use.

Rule Functions

ELCOMPN TM1 Function: How to Use & Syntax

In TM1 and Planning Analytics, ELCOMPN returns the number of children an element has Full syntax and explanation for use.

TI Functions

DimensionElementInsertDirect Function: Syntax & Use

DimensionElementInsertDirect directly adds a new element to a TM1 dimension immediately – no need to wait for the end of the TI step.

Rule Functions

ELISPAR TM1 Function: Use and Syntax

ELISPAR tests if an element is a direct child of a parent in a dimension in TM1. Here we explain how to use it, provide examples and compare it to ELISANC.

Rule Functions

ConsolidatedAvg TM1 Function: How to Use, Example, and Syntax

ConsolidatedAvg is used to calculate the average of rolled up values at the consolidated level. Here it’s explained in detail with a worked rule example.

Cognos Analytics

ViewConstruct TM1 Function: Syntax and Use

The ViewConstruct function allows you to regenerate a view via a TI so it is then saved in memory on the server. Here we explain the syntax and how to use it.

Rule Functions

Rounding in TM1 – The Complete Guide!

ROUND and ROUNDP are often confused and users expect them to behave the same as the Excel function. They are very similar but are different to the Excel treatment. Here is a complete explanation of both functions, a comparison to Excel ROUND and screenshots of the usage of both functions.

TI Best Practices

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.

StringToNumber TM1 Process: Use and Syntax

StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.

DimensionElementPrincipalName, How to Use and Syntax

DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.

TM1 Clear Attribute – an AttrClear Function

The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example