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

DNLev function for IBM Planning Analytics (TM1)

    DNLev returns the number of levels in a dimension

    In the video, DNLev will be used to return the number of levels in the Account dimension.

    Where can the DNLev function be used?

    Excel, Rules and TurboIntegrator

      Which TM1 Server version is the DNLev function available for?

      Version 11 and 12

        What is the syntax for DNLev?

        DNLev(TM1ServerName:Dimension)

        • TM1ServerName = Name of the TM1 Server
        • Dimension = Name of the Dimension

        Relevant Functions

        • DFrst = Returns the first element in a dimension
        • DimIx = Returns an element’s index number in a dimension
        • DimNm = Returns an element’s primary name based on an index in a dimension
        • DimSiz = Returns the number of elements in a dimension
        • DNext = Returns the next element based on the index in a dimension
        • DNLev = Returns the number of levels in a dimension
        • DType = Returns the element type in a dimension