TM1 Function for Excel, DTYPE
DTYPE returns the element type in a dimension.
Where can the DTYPE function be used?
Excel
Which TM1 Server version is this function available for?
Version 11 and 12
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.