Excel Functions

TM1 Function – DNEXT

Available In



DNEXT returns the next element based on the index in a dimension.


DNEXT (TM1ServerName:Dimension, element)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = The name of element in the Dimension


In the Account dimension, return the next element after ‘Net Income %’.

Here is a list of all the elements in index order from the Account dimension.

The element after ‘Net Income %’ is ‘Operating Profit %’

In Excel:

DNEXT(“AdventureWorks:Account”, “Next Income %”) returns Operating Profit %.

Video Demo