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

DNext function for IBM Planning Analytics (TM1)

    DNext returns the first element in a dimension.

    In the video, DNext will be used on the Account dimension to return the next element after Net Income %.

    Where can the DNext function be used?

    Excel, Rules and TurboIntegrator

      Which TM1 Server version is the DNext function available for?

      Version 11 and 12

        What is the syntax for DNext?

        DNext(TM1ServerName:Dimension, element)

        • TM1ServerName = Name of the TM1 Server
        • Dimension = Name of the Dimension
        • Element = The name of an element in 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
        • DType = Returns the element type in a dimension
        • DNLev = Returns the number of levels in a dimension
        • TabDim = Returns the dimension name in a cube based on an index