DIMNM

DIMNM returns the element of a dimension that corresponds to the index argument.

This function is valid in both rules and TurboIntegrator processes.

Syntax

DIMNM(server_name:dimension, index,alias)

Argument

Description

dimension

A valid dimension name qualified by the database name.

index

A value less than or equal to the number of elements in the dimension.

If this argument is less than 1, or greater than the number of elements in the dimension, the function returns 0.

alias

The name of an existing attribute defined for the dimension.

If a valid argument is specified, the function returns the description for the corresponding alias. Otherwise, the function returns the Member ID.

Example

This example returns 'Belgium', which is the description associated with the specified alias for the element at index 2 in the Region dimension.

DIMNM(planning_sample:'Region',2,MyAlias)