TM1 Function for Excel, SUBNM

SUBNM returns an element from a dimension set. If the optional alias parameter is included, the function returns the alias for the element.

Where can the SUBNM function be used?

Excel

What is the SUBNM function?

SUBNM returns an element from a dimension set. If the optional alias parameter is included, the function returns the alias for the element. The formula transforms the cell into a drop-down and can open to the set editor by double-clicking on the cell.

What is the syntax for SUBNM?

SUBNM(TM1ServerName:Dimension, Set, Element Name or Index, Alias)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Set = The name of the set
Element Name or Index = The name or index of the element
Alias = The alias name of the element (OPTIONAL)

A demonstration on how to use SUBNM

Set up two cells to get the elements Bike Racks and Mountain Bikes from the Product Type dimension. Demonstrate the drop-down feature and ability to open the set editor.