How to Get an Element ID from an Alias in an TM1 Excel Report

Need to get a primary element name from an alias in a TM1 Excel report? Simple solution for deriving an element principal name in Excel.

DimensionElementDelete Function TM1: Syntax and Use

Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the dimension and all associated data from any cube the dimension is used in – so please be careful!

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.

Deriving an Element from an Alias in TM1

How do you derive an element ID from an alias or attribute in TM1?


DIMIX TM1 Function: Use, Syntax and Examples

An in depth explanation of the usage of the DIMIX Function in Turbo Integrator Processes and Rules in TM1 and Planning Analytics. In short, to assess if a variable exists as either an element or an alias in a TM1 dimension.

IF in Turbo Integrator processes in TM1: Use, Syntax and Examples

IF is a function that can be used to test if an expression is true so that you…

DimensionElementComponentAdd TM1 Function: Use and Syntax

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

3 Types of TM1 Rules All Developers Should Know

Here we discuss how to do three rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There are full explanations and the code used for the rule examples.

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement