TM1 Function for Excel, DIMNM
DIMNM returns an element’s member ID based on an index in a dimension.
Available In
Where can the DIMNM function be used?
Excel, Rules and TurboIntegrator
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.