DE.NAME

Returns the name of an element in a dimension. If you double-click a cell containing this function, the Dimension Browser opens to let you select an element. The function then returns the element you select and changes the specified index number to the name of the element.

If you enter an element name on top of this function, the function is not overwritten. It takes the name of the element you entered. If the element you enter is not in the specified dimension, the function returns a #Value error.

Syntax

DE.NAME(Database alias,Dimension,Index)

Dimension is the name of the dimension from which you want to get an element and Index is the number of the element within the dimension sequence.

Note: This function looks at the order of the elements within a dimension as they were defined when the dimension was created, not the order of the elements as they are presented by the Dimension Browser, i.e. the index number is the sequence number of the element in the dimension based on the sequence in which the elements were defined when creating the dimension.

If you enter an index number that is greater than the total number of elements (numerical and consolidated) within the dimension, the function returns a #Value error.