Dimensions

Creating Dynamic Subsets in TM1

Dynamic Subsets in TM1 and Planning Analytics allow you to create sets of elements that always contain all relevant elements. For example, all children of a parent, or all level 0 elements. They are extremely useful in Dynamic Reports as with them you can be sure that all elements are displayed.

Display TM1 Attributes in Excel

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1…

ELLEV TM1 Function: How to Use and Syntax

Syntax and Use of ELLEV in TM1 and Planning Analytics to determine the level of a particular element from a dimension.

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…

AttrPutN TM1 Function: Syntax and How to Use

AttrPutN is a TM1 Turbo Integrator function that inserts a numeric value onto a specific attribute for the current…

AttrPutS and AttrPutN Doesn’t Work!

Attribute Definition Problem I just had an instance where I was adding new elements to a dimension in TM1…

AttrPutS in TM1: How to Use and Syntax

Syntax and use for AttrPutS for assigning a string to an attribute on an element in a TM1 dimension via a Turbo Integrator (TI) script for TM1 and Planning Analytics, with a warning about using it on the same TI tab as a DimensionElementInsert.

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.

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