Elements

DimensionElementPrincipalName, Syntax and Use

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

Changing Element Order in a TM1 Dimension

How to set the order of elements in a dimension in TM1, either manually via the Dimension Editor, automatically via TM1 Server Explorer or within a Turbo Integrator process – and why you should be very careful when using it!

ELLEV TM1 Function: Use and Syntax

The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax…

DimensionElementComponentDelete TM1 Function: Use and Syntax

DimensionElementComponentDelete selects a single element and deletes it from a consolidation element in a dimension in TM1. Importantly, it…

DIMNM TM1 Function: Use and Syntax

The TM1 function DIMNM returns the name of an element from its index in a TM1 dimension. Each element…

DimSiz TM1 Function: Use and Syntax

The TM1 function DimSiz returns the total number of elements in a TM1 dimension. Syntax of DimSiz The…

DimensionSortOrder TM1 Function: Use and Syntax

Explanation and example of sorting a dimension in TM1 or Planning Analytics via a Turbo Integrator process using the DimensionSortOrder function.

How to Pad a Variable Length Element in TM1

Often we have a situation were we want to create a dimension with the contents of a code from…

Attributes in TM1

Attributes are one of the core components of TM1. They allow you to describe and categorise elements, use alternate descriptions or IDs and to build virtual hierarchies and dimensions.

TM1: Top N Elements from a Tuple

Writing MDX statements is a very helpful skill for a TM1 person, but what if you need to…

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