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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book