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.
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 […]
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 […]
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 ( DimName ); 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 […]