TM1 Function for Excel, DTYPE
DTYPE returns the element type in a dimension.
Where can the DTYPE function be used?
Excel
What is the DTYPE function?
DTYPE returns the element type in a dimension.
What is the syntax for DTYPE?
DTYPE (TM1ServerName:Dimension, element)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = Element within the dimension
A demonstration on how to use DTYPE
In the Account dimension, return the element type for Net Income and Trade Sales.