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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book