TM1 Function – DIMNM
Available In
Excel
Definition
DIMNM returns an element’s member ID based on an index in a dimension.
Syntax
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
Example
In the Account dimension, return the element that is indexed to 10. Once returned, use the ‘description’ alias to return its alternate name.
In the ‘Account’ dimension, the member ID for the 10th element is ‘1130’.
Through the ‘Description’ alias, the alternate name is ‘Trade Receivables’.
In Excel:
DIMNM(“AdvenutreWorks:Account”, 10) returns 1130.
DIMNM(“AdvenutreWorks:Account”, 10, “Description)
By adding the alias, ‘Description’, after the index number, ‘Trade Receivables’ is returned.