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.
In the video, SubNm will be used to set up two cells to get the elements Bike Racks and Mountain Bikes from the Product Type dimension.
Excel
Version 11 and 12
SubNm(TM1ServerName:Dimension, Set, Element Name or Index, Alias)