Excel Functions

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.

Video Demo