SubNm function for IBM Planning Analytics (TM1)
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.
Where can the SubNm function be used?
Excel
Which TM1 Server version is the SubNm function available for?
Version 11 and 12
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)