DimensionATTRSL

DimensionATTRSL returns a string attribute value for a specified dimension with respect to a given locale.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

DimensionATTRSL(DimName, AttrName, [LangLocaleCode]);

Argument	Description
DimName	A valid dimension name.
AttrName	The attribute for which you want to retrieve a value. This argument must be a valid attribute of the dimension.
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` (French-Canada) 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` (French) locale. If the attribute value for `fr` is not available, the base attribute value is returned

Argument

Description

DimName

A valid dimension name.

AttrName

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

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 (French-Canada) 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 (French) locale. If the attribute value for fr is not available, the base attribute value is returned

Example

In this example, the function returns the string value of the Manager attribute of the Plan_Business_Unit dimension for the French locale.

DimensionATTRSL('Plan_Business_Unit', 'Manager', 'fr');