Excel Functions
TM1 Function – DTYPE
Available In
Excel
Definition
DTYPE returns the element type in a dimension.
N = numeric element
C = consolidated element
S = string element
Syntax
DTYPE (TM1ServerName:Dimension, element)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = Element within the dimension
Example
In the Account dimension, return the element type for ‘Net Income’ and ‘Trade Sales’.
‘Net Income’ is a consolidated element.
Trade Sales is a numeric element.
In Excel:
DTYPE(“AdventureWorks:Account”, “Net Sales”) returns ‘C’
DTYPE(“AdventureWorks:Account”, “Trade Sales”) returns ‘N’