Cubewise
ConsultingEducationSoftwareKnowledge HubSupportCompany
GB
    global-search

    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.