TM1 Function for Rules, DIMNM
DIMNM returns an element’s primary name based on an index in a dimension.
Where can the DIMNM function be used?
Excel, Rules and TurboIntegrator
Which TM1 Server version is this function available for?
Version 11 and 12
What is the DIMNM function?
DIMNM returns an element’s primary name based on an index in a dimension.
What is the syntax for DIMNM?
DIMNM(Dimension, Index)
Dimension = Dimension Name
Index = A value less than or equal to the number of elements in the dimension.
A demonstration on how to use DIMNM
In the System info cube, we will use Calendar Year to retrieve the name of the index number 15 in the dimension Year.