DE.TYPE

Returns the type (for example, base element) of a specified element.

Syntax

DE.TYPE(Database alias,Dimension,Element)

Dimension is the name of the dimension and Element is the element whose type you want to determine.

The function returns these following codes:

• N for base elements
• C for consolidated elements
• S for string elements
• R for rules elements

See Creating and Editing Dimensions (Creating dimensions).

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

If an element does not exist or is not a member of Dimension, the function returns a #Value error.