<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>
Cubewise
ConsultingEducationSoftwareKnowledge HubSupportCompany
GB
    global-search

    TM1 Function for Excel, DNLEV

    DNLEV returns the number of levels in a dimension.

    Where can the DNLEV function be used?

    Excel

    Which TM1 Server version is this function available for?

    Version 11 and 12

    What is the DNLEV function?

    DNLEV returns the number of levels in a dimension.

    What is the syntax for DNLEV?

    DNLEV (TM1ServerName:Dimension)
    TM1ServerName = Name of the TM1 Server
    Dimension = Name of the Dimension

    A demonstration on how to use DNLEV

    Return the number of levels in the Account dimension.