TM1 Function for Excel, DIMNM
DIMNM returns an element’s member ID 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 member ID based on an index in a dimension.
What is the syntax for DIMNM?
DIMNM (TM1ServerName:Dimension, index, Alias)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Index = Index Number for Element required
Alias = If you want to show the Alias rather than the element (OPTIONAL)
A demonstration on how to use DIMNM
In the Account dimension, return the element that is indexed to 10. Once returned, use the Description alias to return its alternate name.