Dimensions

Attributes, Rule Functions, TI Functions

ATTRN TM1 Function: How to Use and Syntax within TI and Rules

ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element…
Dimensions, Dynamic Reports, MDX

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.
Attributes, Excel Functions

Display TM1 Attributes in Excel

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1…
Elements, Rule Functions, TI Functions

How to Find the Level of an Element in TM1: ELLEV Use and Syntax

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

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…
Elements, Rule Functions, TI Functions

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…
Elements, Rule Functions, TI Functions

DimSiz TM1 Function: Use and Syntax

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

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…
Attributes, TI Errors

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
Attributes, TI Functions

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.

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

Subscribe Now