Category Archives: Elements

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!

This entry was posted in Elements and tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element. Bookmark the permalink. | Tagged Dimension Editor, Dimension Maintenance, dimension order, DimensionSortOrder, Element | Leave a comment

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 The syntax is ELLEV(dimension, element); where: dimension, is the dimension you are interrogating, and element, is the element you want the level number for Use of ELLEV This function is used to determine the level of a specific element in a dimension.  It is often used in conjunction with an IF statement to … Continue Reading

This entry was posted in Elements, Rule Functions, TI Functions, TI Processes and tagged ATTRS, ELLEV, ITEMSKIP. Bookmark the permalink. | Tagged ATTRS, ELLEV, ITEMSKIP | Leave a comment

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 does not delete the element from the dimension itself, it only removes it from being rolled up to the specified parent. For the opposite, please see DimensionElementComponentAdd. Syntax of DimensionElementComponentDelete The syntax is DimensionElementComponentDelete(DimName, ConsolidatedElName, ElName); where DimName, is the dimension you want to modify ConsolidatedElName, is the consolidated element you want to remove the … Continue Reading

This entry was posted in Elements, TI Functions. Bookmark the permalink. | 1 Comment

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 in a TM1 dimension has an index number.  This is internal to the dimension. The DimNm function looks up that index number and returns the element name corresponding to it. Syntax The syntax is DIMNM(dimension, index); where Dimension, is the dimension you want to interrogate. Note that if referring to a dimension … Continue Reading

This entry was posted in Elements, Rule Functions, TI Functions. Bookmark the permalink. | Leave a comment

DimSiz TM1 Function: Use and Syntax

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 number of elements (note that you may need to prefix the dimension name with the TM1 server name in the syntax servername:dimension). Use and Example You would typically use this function in to set up a loop so you can … Continue Reading

This entry was posted in Elements, Rule Functions, TI Functions and tagged DIMSIZ, WHILE. Bookmark the permalink. | Tagged DIMSIZ, WHILE | Leave a comment

DimensionSortOrder TM1 Function: Use and Syntax

DimensionSortOrder is used to sort a dimension from within a Turbo Integrator (TI) process. Syntax of DimensionSortOrder DimensionSortOrder ( DimName , CompSortType , CompSortSense , ElSortType , ElSortSense); where: DimName, is the dimension to be sorted. CompSortType, sets the order for Consolidated elements. ByInput (the order used is the order the elements were added to the dimension) or ByName (the order used is alphabetic on the field chosen). CompSortSense, Ascending or Descending ElSortType, sets … Continue Reading

This entry was posted in Elements, TI Functions. Bookmark the permalink. | 1 Comment

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 a source system.  Sometimes, however the IDs in the source system are of a variable length and we want to present them uniformly.  To overcome this, we need to pad the code at the left with a constant character to make them all the same length. the method below will pad out … Continue Reading

This entry was posted in Elements, TI Processes. Bookmark the permalink. | Leave a comment

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 automate this task and generate many MDX statements? TI process in conjunction with excel formulas might save you in this tricky situation. Say the requirement is to have Top 5 lists of products in each product category or in each country or Top 3 products for Top 3 product categories. In this … Continue Reading

This entry was posted in Elements, TM1Top and tagged TM1Top. Bookmark the permalink. | Tagged TM1Top | Leave a comment