DimNm function for IBM Planning Analytics (TM1) – Excel

Where can the DimNm function be used?

Which TM1 Server version is the DimNm function available for?

What is the syntax for DimNm?

• 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)

Relevant Functions

• DFrst = Returns the first element in a dimension
• DimIx = Returns an element’s index number in a dimension
• DimNm = Returns an element’s primary name based on an index in a dimension
• DimSiz = Returns the number of elements in a dimension
• DNext = Returns the next element based on the index in a dimension
• DType = Returns the element type in a dimension
• DNLev = Returns the number of levels in a dimension
• TabDim = Returns the dimension name in a cube based on an index