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.

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

Posted on Dec 14, 2020 by John

Have you ever needed to derive the primary element name from a TM1 alias in Excel? Essentially, do the equivalent of DimensionElementPrincipalName (a TI and Rule function) in a TM1…

DimensionElementPrincipalName, How to Use and Syntax

Posted on Sep 19, 2019 by John

Today I needed to lookup an element ID from an alias in a TI process.  I found the DimensionElementPrincipalName function that looks up the TM1 element principal name from the…

How to Change Element Order in a TM1 Dimension

Posted on Oct 10, 2017 by John

TM1 has a feature that allows you to change the order of elements (sometimes known as members) in a dimension (note this is changing element order in a dimension, not…

ELLEV TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax The syntax is ELLEV(dimension, element); where: dimension, is the dimension you are…

DimensionElementComponentDelete TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

DimensionElementComponentDelete selects a single element and deletes it from a consolidation element in a dimension in TM1. Importantly, it does not delete the element from the dimension itself, it only removes…

DIMNM TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The TM1 function DIMNM returns the name of an element from its index in a TM1 dimension. Each element in a TM1 dimension has an index number.  This is internal to…

DimSiz TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The TM1 function DimSiz returns the total number of elements in a TM1 dimension. Syntax of DimSiz The syntax is DIMSIZ(dimension); where dimension is the dimension you want to get the total…

DimensionSortOrder TM1 Function: Use and Syntax

Posted on Mar 18, 2015 by John

DimensionSortOrder is used to sort a dimension from within a Turbo Integrator (TI) process. Syntax of DimensionSortOrder The syntax is: DimensionSortOrder ( DimName , CompSortType , CompSortSense , ElSortType , ElSortSense); …

How to Pad a Variable Length Element in TM1

Posted on Mar 18, 2015 by John

Often we have a situation were we want to create a dimension with the contents of a code from a source system.  Sometimes, however the IDs in the source system are…

TM1: Top N Elements from a Tuple

Posted on Jul 22, 2013 by Ivan.Kulman

Writing MDX statements is a very helpful skill for a TM1 person, but what if you need to automate this task and generate many MDX statements? TI process in conjunction…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!