Excel Functions
TM1 Function – DNEXT
Available In
Excel
Definition
DNEXT returns the next element based on the index in a dimension.
Syntax
DNEXT (TM1ServerName:Dimension, element)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = The name of element in the Dimension
Example
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 %.