DTYPE

DTYPE returns information about the specified member.

DTYPE returns C if the member is a consolidated member, N if the member is a numeric member, and S if the member is a string member.

In the case of an element attribute dimension, DTYPE returns AN if the attribute is a numeric attribute, AS if the attribute is a string attribute, and AA if the attribute is an alias attribute. For more information, see Element Attributes.

Syntax

DTYPE(server:dimension, element)

Argument

Description

Required/Optional

server:dimension

The name of the TM1® server and a dimension name.

Required

element

The name of a member within the dimension. This argument can also be the name of an alias for a dimension member.

Required

Example

In this example, the TM1 server name is SData. The member Europe in the dimension Region is a consolidated member, so the example returns "C".
DTYPE("SData:Region","Europe")
In this example, the TM1 server name is GO_New_Stores. If the Tents member contains numeric data, such as product numbers, the function returns N. If the Tents member contains text, such as model names, the function returns S.
DTYPE("GO_New_Stores:Products","Tents")