DTYPE function#

DTYPE returns an element's type so you can branch formatting or logic on it. For a normal dimension it returns the element type; for an attribute dimension it returns the attribute type.

DTYPE is a native TM1 / Planning Analytics function.

Signature#

=DTYPE("Server:Dimension", element)

Arguments#

#	Argument	Type	Required	Permitted values and notes
1	`Server:Dimension`	String	Yes	`"server:dimension"`. If the dimension name begins with `}ElementAttributes_`, `DTYPE` reads an attribute type instead of an element type.
2	`element`	String	Yes	Element name, or attribute name for an attribute dimension.

DTYPE takes exactly two arguments. The default result is an empty string.

Return values#

Result	Meaning
`N`	Numeric element
`S`	String element
`C`	Consolidated element
`AN`	Numeric attribute (attribute dimension)
`AS`	String attribute (attribute dimension)
`AA`	Alias attribute (attribute dimension)

What happens when an argument is wrong#

For the shared error model and the Calc Mode effect, see how Reportworq handles errors.

Situation	Result
More than two arguments	Hard error
Fewer than two arguments	Warning, blank
An invalid attribute on an attribute dimension	Warning, blank
An unknown element or attribute type	Hard error
Dimension or element not found	Warning, blank

Examples#

=DTYPE("PlanTM1:Region", "Northeast")
=DTYPE("PlanTM1:}ElementAttributes_Region", "Manager")

IBM Planning Analytics functions - the function index and the shared error model.
DBRA function - retrieve an element attribute value.

Feedback on this page

Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.

Email feedback on this page

Or write to support@reportworq.com directly.