TM1 Function for Excel, DNEXT
DNEXT returns the next element based on the index in a dimension.
Where can the DNEXT function be used?
Excel
What is the DNEXT function?
DNEXT returns the next element based on the index in a dimension.
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 element in the Dimension
A demonstration on how to use DNEXT
In the Account dimension, return the next element after Net Income %.