ATTRNL

ATTRNL returns a numeric attribute for a specified element of a dimension.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

ATTRNL(DimName, ElName, AttrName, [LangLocaleCode]);

Argument

Description

DimName

A valid dimension name.

ElName

An element of the dimension.

AttrName

The attribute for which you want to retrieve a value. This argument must be a valid attribute of the element.

LangLocaleCode

This optional parameter specifies the language locale code for which you want to return a value.

Valid LangLocaleCode values correspond to the international language codes listed in the }Cultures control dimension.

When the LangLocaleCode is not specified or is omitted, the user's current locale is used as the LangLocaleCode argument.

If an attribute value does not exist for the LangLocaleCode, the value for an associated parent LangLocaleCode is returned. If an attribute value does not exist for an associated parent LangLocaleCode, the base attribute value is returned.

For example if the LangLocaleCode is fr-CA, the function returns the attribute value for the fr-CA locale if available. If the attribute value for fr-CA is not available, the function attempts to return the attribute value for the parent fr locale. If the attribute value for fr is not available, the base attribute value is returned

Example

In this example, the function returns the numeric value of the Engine Size attribute of the L Series 1.8L Sedan element in the Model dimension for the French locale.

ATTRNL('Model', 'L Series 1.8L Sedan', 'Engine Size', 'fr');