Monthly Archives: March 2015
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
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
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
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
AttrPutN is a TM1 Turbo Integrator function that inserts a numeric value onto a specific attribute for the current element in a specified dimension. Note that this function does not insert a string into an attribute. To insert a string value into an attribute please see AttrPutS. Syntax of AttrPutN The syntax is AttrPutN(Value, DimName, ElName, AttrName, [LangLocaleCode] ); value, is the number that you want to insert dimname, is the dimension that you want … Continue Reading
Attribute Definition Problem I just had an instance where I was adding new elements to a dimension in TM1 and then wanted to define an attribute for those new elements. Easy, yeah? Just test if an element is there with a Dimix, then use a DimensionElementInsert and then an AttrPutS or AttrPutN to define the attribute. Well, not quite. I had it all on the metadata tab, but even though the … Continue Reading
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.
Explanation and example of sorting a dimension in TM1 or Planning Analytics via a Turbo Integrator process using the DimensionSortOrder function.
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
I have been using attributes since I started working with TM1 and are often asked what are they and what are they used for. What are Attributes in TM1 TM1 Attributes are a way of adding relevant information to elements in dimensions. For example, an attribute of a date element might be the day of the week, or the number of business days passed in a month. Or for a … Continue Reading