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")