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’

Video Demo