SUBNM

SUBNM returns the element of a dimension subset.

If you include the optional Alias parameter to this function, the function returns the alias for the selected element.

You can double-click the cell that contains a SUBNM formula and the Subset Editor will open if the package that contains the SUBNM formula dimension is selected.

Syntax

SUBNM(Dimension, Subset, IndexOrName, [Alias])

The arguments are described in the following list.

Dimension

A valid dimension name.

Subset

The name of a subset of the dimension.

IndexOrName

An index into the subset or the name of an element in the subset.

If an index, a positive integer less than or equal to the total number of elements in the specified subset. If a name, a string representing the name of an element of the subset.

Important: Index is not currently supported. You must provide the name of an element.

Alias

The name of an alias that exists for the subset. This is an optional argument. If it is used, the specified alias is applied when the Subset Editor opens and the function returns the alias for the selected element.

Example

SUBNM("Region","Top Producers",2)

The Top Producers subset of the Region dimension contains the ordered elements United States, Germany, Great Britain, and Mexico. Because the Index argument points to the second element in the subset, the example returns Germany.

SUBNM("Region","Top Producers","Germany","Deutsch")

This example returns the Deutsch alias for the Germany element (Deutschland) from the Top Producers subset of the Region dimension.